Re: Query speed difference using range vs. exact match

Jon Dallara recently posted: > Hi All; > > While working on a project, I noticed that some queries were taking > longer to complete than others. Specifically, queries that search for > an exact date match were taking much longer than those that used a range, > even though the range was only 1 day. I was wondering if: a.) have others > seen this or is it only me ( I hope not ); b.) there is an explaination > for this seemingly backwards operation ( I'd expect a range to take longer ). [timing info deleted] Not to worry, Jon. Most have us have seen this as well. As I understand it, when using the MATCHES phrase INFORMIX does not use and indices present. Rather, it checks each record against the MATCHES argument. ========================================================================== == George Teachman == == Soil Scientist == == United States Department of Agriculture - Soil Conservation Service == == Fort Collins, Colorado == == 303-282-1960 == == == == george@talon.ftc.scs.ag.gov == == ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ == == Welcome to earth, third rock from the sun. Cause and effect. == == There are only three laws of nature, and one exception. == == 1) F=ma; 2) E=m(c squared); 3) You can't push a rope == == From these three laws all others can be derived. == == Except those explained by CHAOS THEORY. == ==========================================================================