| Subject | Re: [ib-support] Re: containing, like, = |
|---|---|
| Author | Lucas Franzen |
| Post date | 2001-09-04T07:05:37Z |
> ...LIKE 'XY%' can be replaced by STARTING WITH (which uses indexes), so I
> I think LIKE 'XY%' use indexes, but LIKE '%XY%' doesn't.
think this is what's happening internally.
Luc.