create nonclustered Index
Idx_salesOrderID_salesOrderDetailID
on sales.salesorderdetail(salesorderid,salesorderdetailid)
Idx_salesOrderID_salesOrderDetailID
on sales.salesorderdetail(salesorderid,salesorderdetailid)
Wednesday 9 October 2013
04. The SalesOrderDetail table is often queried. The queries are based on the SalesOrderDetailID and SalesOrderID attributes. The execution of the queries takes a long time. Optimize the execution of the queries. In addition, check the performance of the query before and after optimizing the execution of the queries.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment