How SQL Server FTS Works
The two main components of FTS are as follows:
Indexing—Extracts the textual content and in some cases properties (more later) from your data and stores the words or tokens in inverted file indexes. Statistics are collected on the words and phrases to allow for semantic analysis and queries.
Searching—Queries these inverted file indexes and returns the rows that match the query.
Get Microsoft® SQL Server 2012 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.
