MS SQL Server XML Integration Interview Question:

What are secondary XML indexes?

Submitted by: Administrator

XML indexes can either be primary or secondary. When the XML type column has its first index, it is called as a primary index. Using this primary index, secondary indexes like PATH, VALUE and PROPERTY are supported. Depending on the nature of queries, they help in query optimization.

Path secondary index if used speeds up queries if the query specifies a path.

Path secondary index if used speeds up queries are value based.

Path secondary index if used speeds up queries if the query retrieves one or more values from individual XML instances.
Submitted by: Administrator