Full-text indexes

Full-text indexes have been included in SQL Server since SQL Server 7.0, although they have changed drastically in implementation over the last few releases. In SQL Server 2008, the data structures for full-text search were brought into the database; before then, the full-text search indexes were run in instances of Microsoft Search Server. In SQL Server 2008, the index itself resides in the database as a set of internal tables, and most of the indexing and processing is done inside the SQL Server process. This section concentrates on the SQL Server 2012 implementation, which is similar to the SQL Server 2008 implementation with a number of performance enhancements and some additional features.

As opposed to XML and spatial data, ...

Get Microsoft SQL Server 2012 Internals now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.