Re: a little help with query.

Posted in 2009

Floyd Wellershaus — Thu, 16 Jul 2009 05:56:06 -0500 (CDT) — source: Usenet: comp.databases.informix

It didn't work the way you said. It's using the index but still doing (Parallel, fragments: All). Not key only. Thanks, floyd ----- Original Message ----- From: "Vagner" <pontes.vagner@gmail.com> Sent: Wed, July 15, 2009 18:56 Subject:Re: a little help with query. Hi, When you put the filter on varchar_column column the engine works on data pages to process your count, because IS NOT NULL or != filter is not applied to index, for test purposes try to put varchar_column=some value, the access plan will be "Key Only" Without the filter probably your access plan is "Key Only", in this access plan your count(distinct .. ) works only on the index pages. Because this your query is faster without the filter, to ceck my teory verify your access plan without the filter. Regards Vagner _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ----- End of original message -----