Abstract
Performance efficiency is always a top concern for DBAs and developers. Indexes are a front runner to improve data delivery processes. However, the logical tree structure of XML data cannot be indexed in the same way as plain old relational data. Therefore, with the introduction of SQL Server 2005, Microsoft added an indexing mechanism for XML data type columns. XML data is not the same as scalar data in a table’s column, therefore the XML indexing mechanism provides for specialized primary and secondary XML indexes. In SQL Server 2012, the XML indexes are enhanced with a Selective XML Index, which provides an improvement in search efficiency for big XML data.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Alex Grinberg
About this chapter
Cite this chapter
Grinberg, A. (2018). Improving XML Performance. In: XML and JSON Recipes for SQL Server. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3117-3_7
Download citation
DOI: https://doi.org/10.1007/978-1-4842-3117-3_7
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-3116-6
Online ISBN: 978-1-4842-3117-3
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)