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 Question | Next Question |
| What are secondary XML indexes? | What is FOR XML in SQL Server? |