This was one of the questions asked for a BI Solutions Architect role interview.
The question was - There is a Datawarehouse that holds 10 years of historical data.
I want to query just the current day's data. How can I improve the performance of my Select query here?
I didn't know the answer but the interviewer suggested that Table Partioning was the way to go.
Sounds logical!
The question was - There is a Datawarehouse that holds 10 years of historical data.
I want to query just the current day's data. How can I improve the performance of my Select query here?
I didn't know the answer but the interviewer suggested that Table Partioning was the way to go.
Sounds logical!