| Subject | Re: [IBO] Searching for a string into a string |
|---|---|
| Author | Svein Erling |
| Post date | 2002-09-12T20:16:33Z |
Sorry Helen,
indexes, but CONTAINING implies that the engine doesn't know if what
it searches for is at the beginning of the field, and hence not where
to lookup in an index.
The only way to get something like this indexed must be to use Jasons
components for free text search (or whatever FTS means).
Set
> WHERE MyStringField CONTAINING 'stre'there is no way CONTAINING can use an index. STARTING [WITH] use
>
> If MyStringField is indexed, then the case-sensitive search will
> use the index (=fast).
indexes, but CONTAINING implies that the engine doesn't know if what
it searches for is at the beginning of the field, and hence not where
to lookup in an index.
The only way to get something like this indexed must be to use Jasons
components for free text search (or whatever FTS means).
Set