Subject Re: [firebird-support] Index vs Containing
Author Helen Borrie
At 12:01 PM 31/08/2005 +0000, you wrote:
>Hi,
>
>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)?

No. If you have a regular need to do fast searches for contained strings,
you might like to consider storing keywords for these strings, or soundexes
if that were appropriate.

./heLen