Wednesday 9 October 2013

10. The Store table is often queried. The queries are based on the Demographics attribute and take a long time to execute. Optimize the execution of these queries.

create XML Index Sdx_Sales_Demographics_path
on Sales.Store(Demographics)
Using XML Index PXML_Store_Demographics
for path

No comments:

Post a Comment