© Jason Strate 2019
J. StrateExpert Performance Indexing in SQL Server 2019https://doi.org/10.1007/978-1-4842-5464-6_4

4. XML Indexes

Jason Strate1 
(1)
Hugo, MN, USA
 

The past couple chapters focused on indexing what is commonly referred to as structured data, where there is a common schema and organization around the data and its storage. In this chapter and the next few chapters, the indexing focus shifts to unstructured and semistructured 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 types of data have differences in how they are stored in the database. These differences dictate how and why indexing is implemented ...

Get Expert Performance Indexing in SQL Server 2019: Toward Faster Results and Lower Maintenance 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.