Re: Help! my install of ONLINE 4.00 is 30% slower than Standard Engine

In article <1992Mar26.204539.7416@informix.com> cortesi@informix.com writes: > >Regarding your choice of query, "where description matches '*MEM*'" >will always use a sequential scan. MATCHES (or LIKE) with a leading >wildcard can't use an index. > > Dave Cortesi Hi, Dave! While it may be true to say that MATCHES with a leading wildcard _doesn't_ use an index, isn't it possible that using the index might be faster: since the index will have only this column, amount of data to be searched is only the column we're interested in, and, it is possible that finding a hit may allow inteligent use of Informix's compression scheme to guarantee that the next _n_ rows are hits also? Just wondering if anyone's actually done any looking into this, or if it is one of the things that everybody "just _knows_." thomas rush uunet!cpqhou!thomasr compaq computer corporation their employee, deep in the hearth of texas not their opinions.