| Subject | Re: [ib-support] Re: containing, like, = |
|---|---|
| Author | Helen Borrie |
| Post date | 2001-09-04T07:02:45Z |
At 06:39 AM 04-09-01 +0000, Richard Saeger wrote:
STARTING WITH 'XY' will be much more effective because STARTING WITH uses an index unconditionally (if there is one, of course).
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
>I think LIKE 'XY%' use indexes, but LIKE '%XY%' doesn't.IMO, it's not worth doing a LIKE 'XY%' (no, I don't think LIKE ever uses an index).
>
STARTING WITH 'XY' will be much more effective because STARTING WITH uses an index unconditionally (if there is one, of course).
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________