Subject | Re: [firebird-support] Index vs Containing |
---|---|
Author | Helen Borrie |
Post date | 2005-08-31T12:32:46Z |
At 12:01 PM 31/08/2005 +0000, you wrote:
you might like to consider storing keywords for these strings, or soundexes
if that were appropriate.
./heLen
>Hi,No. If you have a regular need to do fast searches for contained strings,
>
>I'm using the "containing" keyword in a select and can see it doesn't
>uses the index for the column, is it normal? If yes, is there another
>way to use the index in this case (search a text in any position of a
>varchar column)?
you might like to consider storing keywords for these strings, or soundexes
if that were appropriate.
./heLen