Which Words will be indexed or are indexed by FTS

With the SQL Server 2008 a few new DMVs and DMFs are introduced. In this post i will try to describe two of them which are related to Full-Text Search.

Firstly when we do search by using FTS  we don’t know if  words are indexed or not. If you want to retrieve the words to be indexed on a table or view by the FTS, you can use sys.dm_fts_index_keywords.

select * from sys.dm_fts_index_keywords(db_id('BlogDb'),object_id('tbl_user_documents'))

Secondly if we want to know which words will be indexed, we can use sys.dm_fts_parser DMF.

select * from sys.dm_fts_parser(N'"i do not want to go to school"',0,0,0)


Technorati Etiketleri: ,,,,

Hiç yorum yok: