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