Re: Query speed difference using range vs. exact match

George Teachman (george@talon.ftc.scs.ag.gov) wrote: > 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. MATCHES is used for CHARs. Be sure to UPDATE STATISTICS first. Also, is the column indexed? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- +-+-+-+-+-+ Danni Bauer |D|a|n|n|i| bauer@gtetel.com +-+-+-+-+-+ 73764.63@compuserve.com