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?
"Here is a test to find out whether your mission in life is complete. If you're alive, it isn't. "
Richard Bach