Re: Optimizing Select count distinct statement

If field2 is part of a multiple field index then run update statistics high on that field. I have encountered this with 7.2. It ignores a multiple field index when you use only one field. staccuc@riq.qc.ca wrote: : Anyone has an idea on how to optimize this kind of statement : select count (distinct field1) : from table1 : where field2 = 'something' : There is indexes on both field1 and field2, but Informix Online 7.2 is : not using them according to the explain plan. : Any idea ? : Thank you -- And I still use vi.........