MS SQL Server XML Integration Question:

What are XML indexes?

SQL Server XML Integration Interview Question
SQL Server XML Integration Interview Question

Answer:

XML indexes are created on XML data type columns. Having XML indexes will reduce cost with respect to maintenance and data modification. Use of XML indexes avoids the need to parse the complete data at runtime thereby increasing query processing efficiency.


Previous QuestionNext Question
What are secondary XML indexes?What is FOR XML in SQL Server?