What if I create two indexes as below:
CREATE INDEX IDX_DATE
ON Transaction_Date
CREATE INDEX IDX_LOCATION
ON Location_ID
INCLUDE (Vertical_ID, Customer_Id)
"Here is a test to find out whether your mission in life is complete. If you're alive, it isn't. "
Richard Bach