What is the importance of sys.xml_indexes?

 Posted by Niladri.Biswas on 4/26/2013 | Category: Sql Server Interview questions | Views: 1362 | Points: 40
Answer:

The catalog view sys.xml_indexes is similar to sys.indexes. This catalog view returns one row per XML index in a database.

The view includes information on whether the XML index is a primary or secondary XML index. If the XML index is a secondary XML index, the catalog view includes a type for the secondary index.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response