Abstract
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, 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 as well as how the indexes are used by the query optimizer. SQL Server has a specialized data type for storing the most common type of unstructured and semistructured data, XML. This chapter explores the types of indexes offered by SQL Server for dealing with XML data. The chapter will also show the impact of those indexes on the types of queries that can be written against XML data using XQuery and the impact on the choices made by the optimizer.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Electronic Supplementary Material
Below is the link to the electronic supplementary material.
Rights and permissions
Copyright information
© 2015 Jason Strate and Grant Fritchey
About this chapter
Cite this chapter
Strate, J., Fritchey, G. (2015). XML Indexes. In: Expert Performance Indexing in SQL Server. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1118-2_4
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1118-2_4
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1119-9
Online ISBN: 978-1-4842-1118-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books