Re: Informix help

Posted in 1996

Billy Wheeler — 4 Jan 1996 10:18:05 -0500 — source: Informix-list mailing list archive (1991-1998)

[SNIP due to New Year hangover making the thought of DATETIME fields induce nausea] >3, Index qestion, if I have a index which uses 2 field and my > query only fill one of the 2 fields, will it still use that > index ?? Partial indexing ? If the query uses the first field(s), it will still use the index. HTH. Blurg. :) -- Cheers, Billy "Have you got it yet?" (c) Dazza, 1995