Wednesday 9 October 2013

02. The Store table is often queried. The queries are based on the CustomerID attribute and take a long time to execute. Optimize the execution of the queries. In addition, ensure that the CustomerID attribute does not contain duplicate values.

select * from Sales.Store
create Unique nonclustered index
IDx_CustomerID on sales.Stare(CustomerID)

No comments:

Post a Comment