Re: Query speed difference using range vs. exact match

>George Teachman (george@talon.ftc.scs.ag.gov) wrote: >> Jon Dallara recently posted: >> > Hi All; >> > >> > ... >> [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? I believe MATCHES will use an index if it can. If the "?" or "*" wildcards are at the front of the string, then indecies cannot be used. so: MATCHES "*string" will NOT use an index, but MATCHES "str*ng" WILL use an index on that column. ======================================================================= Dennis J. Pimple dennisp@informix.com Opinions expressed Senior Consultant -------------------- are mine, and do not Informix Software Inc Voice: 303-850-0210 necessarily reflect Denver Colorado USA Fax: 303-779-4025 those of my employer.