@RDBMS (3/16/2014)
So according to your suggestion, the index would be:CREATE INDEX IDX_LOCATION_DATE
ON Location_Id, Transaction_Date
INCLUDE (Vertical_ID, Customer_Id)
After creating this index, how can I determine whether it is performing well or not?
You can use the logical and physical reads for a query run.
Use
set statistics io on
and use
dbcc dropcleanbuffers
to clear the memory buffer, during your test.
Igor Micev,My blog: www.igormicev.com