0 - 1 of 1 tags for mppi

We have a large transaction table for a global implementation is being created that has the columns Region_Id, Location_Id, and Transaction_Dt. The table contains five years of data and the filters will primarily be on the columns identified. In reviewing the data demographics, below things were observed:
• The Region_Id has 10 distinct values
• The Location_Id has 2,000 distinct values
• The Transaction_Dt typically has 200,000 rows per value

What is the optimal implementation in terms of request performance?