Configuring Full-Text Indexing
SQL Server's full-text indexing feature is what you might call an "aware" indexing option. Normal clustered and nonclustered indexes are based on exact matches. Stated differently, you can only find data values that match your filter exactly. This fact is even true with the LIKE SQL operator. For example, a filter with the clause WHERE Col1 LIKE 'run%' would find values equal to run and running, but not ran. Full-text searches can also locate variant forms such as ran for run.
Additionally, full-text indexes allow for searches based on proximity. You can search for two words that are close to each other. You can also search for words based on weights with higher weighted words appearing first in the results.
Starting ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond 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.
