Re: A never-ending query (almost)

Mike Aubury <mike@aubury.demon.co.uk> writes: >whats the distribution like for the values in field1 ? On average, 200-400 rows for each value of field1. With a typical field1/field2 combination, the number drops to 50-100. >try selecting the number of rows where field1="xxx" is it that with one >value its pulling back only a few rows, but for another its briging >back lots ? No. Informix will grind away for over an hour to pull back <200 rows, while other values of field1 with a similar number of rows come back immediately. Wierd... >-- Mike Aubury Anyway, thanks for the thoughts... -- --- - Derrek (dirk@xmission.com)