How SQL Server FTS Works
As mentioned previously, in SQL Server 2008, the catalogs are now stored inside the full-text engine. This redesign has resulted in many architectural changes in SQL Server 2008 Full-Text Search.
The two main components of Full-Text Search are as follows:
• Indexing Extracts the textual content from your data and stores the words or tokens in inverted file indexes
• Searching Queries these inverted file indexes and returns the rows that match the query
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
