What is the importance of sys.xml_indexes?

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

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