MS SQL Server XML Integration Question:

Download Job Interview Questions and Answers PDF

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.

Download SQL Server XML Integration Interview Questions And Answers PDF

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