>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.