This is a common question that we’ve encountered in the past during our PoC process.
Question:
How can I increase the performance of my queries?
Answer :
Add a where clause(s) constraining by date (the date of the physical load sequence).
For example, to improve performance of:
SELECT Col A, Col B from Table where Col C = x;
Try the following series of queries ...
SELECT Col A, Col B from Table where Col C = x and Date Column
between 2001-01-01 and 2001-12-31;
SELECT Col A, Col B from Table where Col C = x and Date Column
between 2002-01-01 and 2002-12-31;
etc.
SELECT Col A, Col B from Table where Col C = x and Date Column
between 2008-01-01 and 2008-12-31;
IMPORTANT: Be sure that the logical set of queries includes
the full range of dates contained in the Table being queried.
