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