Types of secondary XML indexes available for creation

By Santhosh N

This explains how to create secondary XML indexes and different types of Secondary indexes that can be created for XML Data types in SQL Server

There are three types of secondary XML indexes that are available for creation in SQL Server  and are listed below:

  1. PATH secondary XML index

  2. VALUE secondary XML index

  3. PROPERTY secondary XML index

Note: Primary index needs to be created before creating secondary index(es).

Related FAQs

This explains about the limitations of the XML Data type in Sql Server in terms of creating Index
This explains the difference between the Clustered Index and Non Clustered Index.
You could check if the index created on the table is being used or not by monitoring that and queried
Types of secondary XML indexes available for creation  (1089 Views)