You are a database administrator for AIOTestKing.com. Your company uses a SQL Server 2005 application. The application executes a query that returns three columns of the nvarchar data type and one column of the XML data type. The query uses a WHERE clause that includes all three of the nvarchar columns. The table contains 5 million rows, and the query returns 50,000 rows. You need to improve the performance of the query.
What should you do?
A.
Create a composite index on the three nvarchar columns, and specify INCLUDE for the XML column.
B.
Create a primary XML index on the XML column.
C.
Create statistics on the nvarchar columns.
D.
Create a view that includes only the four columns that the query uses.
Explanation:
By specifying INCLUDE for the XML column you add the nonkey column to the leaf level of the nonclustered index.