JIM.H.


full text indexing

Hi,

In SQL Server 2005, if I set full text indexing enables in column MyDesc and

1. use ¡°Select * from MyTable where MyDesc LIKE ¡®%abc%¡¯¡± would this be using full text indexing Or have to use Contains to get it be in use

2. Once I create the full-text index, should I be setting it to populate periodically Isn¡¯t it populating itself





Re: full text indexing

Jens K. Suessmeyer


Select * from MyTable where MyDesc LIKE ¡®%abc%¡¯


FTS won¡¯t help you with the command

Select * from MyTable where MyDesc LIKE ¡®%abc%¡¯


as it won¡¯t be found with FTS with that wildcards. FTS has special rules to find values, a wildcard at the beginning won¡¯t work unless the word is part of a compund word.


FTS can use eithert manual processes to be populated / updated or use an internal notification system which automagically updates as new values will arrive.

Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---








Re: full text indexing

Upinder

Hi,

I am using full text indexing on a huge amount of data. I am making all kinds of queries i.e. words, phrases, near words, inflectional and thesourous.

My requirement is to highlight the searched words or phrases in the text of the returned rows in the front end.

I am able to do it in case of word and phrase search as i procure the search words at the input stage in the front end, but am not able to do anything in case of inflectional and thesousrus search as they are fired at the back end search engine.

I need to get the words which the MSFTESQL service fire after getting it thru word breakers and stemmers. i.e. the Significant words after going thru all processes in the search engine which are finally fired for the search.

Please reply at the earliest.

Thanks

Upinder singh