Users of the sales application have been complaining about the time it takes to generate the TotalSalesPerDay report. The report is created from the SalesByDate XML data type column in the Sales tables. The TotalSalesPerDay report is fed by the TotalSalesPerDaySP stored procedure, which executes the following query:
SELECT SalesByDate.query(‘/Sales[//@reportDate = sql:variable(“@today”)]’) FROM Sales
How can you improve the performance on this query?
A.
Create a PATH secondary XML index.
B.
Create a PROPERTY secondary XML index.
C.
Create a VALUE secondary XML index.
D.
Create a clustered index on the XML column.