Indexes and Views

Posted in 2000

John Shepherd — Thu, 12 Oct 2000 19:28:12 +0100 — source: Informix-list mailing list archive (1991-1998)

Greetings ! If I have a source table (T) and a view (V) of that table. When my application issues a SELECT against V, how does Informix use indexes ? Is it able to use an index against (T) for the underlying creation of (V) and *then* use another more appropriate index for the SELECT against (V) ? Cheers John