CHAPTER 4

image

XML, Spatial, and Full-Text Indexing

The last couple chapters focused on indexing what is commonly referred to as structured data, where there is common schema and organization around the data and its storage. In this chapter, the indexing focus shifts to unstructured data. With both structured and unstructured data, the task of indexing is to gain optimal efficiency for retrieving and manipulating data, but the data types that represent these different types of data have differences in how they are stored in the database. These differences dictate how and why indexing is implemented. SQL Server has specialized data types and features ...

Get Expert Performance Indexing for SQL Server 2012 now with O’Reilly online learning.

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