Subject | Index question |
---|---|
Author | "Szabó Sándor (Süni)" |
Post date | 2008-09-12T06:33:20Z |
Hi all!
Is there any solution for fast searching against textual data in a
VARCHAR typed column? The search should find any matching pattern in the
mentioned column. I know CONTAINING doesn't use any indexes, so is there
any other solution? There are many records and the search should be fast
enough. I tried XFTS, but it didn't proved its power to me.
TIA:Alex :-)
Is there any solution for fast searching against textual data in a
VARCHAR typed column? The search should find any matching pattern in the
mentioned column. I know CONTAINING doesn't use any indexes, so is there
any other solution? There are many records and the search should be fast
enough. I tried XFTS, but it didn't proved its power to me.
TIA:Alex :-)