Re: Optimizing Select count distinct statement

Posted in 1997

"Billy Wheeler" — 13 Feb 1997 02:48:23 -0500 — source: Informix-list mailing list archive (1991-1998)

On 13 Feb 97 at 4:57, staccuc@riq.qc.ca wrote: > There is indexes on both field1 and field2, but Informix Online 7.2 > is not using them according to the explain plan. The first thing I always say to this kind of question is "Huh?" Then I say "Have you tried UPDATE STATISTICS?" HTH. -- Ciao, Billy "...nod's as good as a wink to a blind bat..."