If your DBQL table archives are defined as PPI tables, do the following:
- Archive DBQL data nightly. This is strongly recommended so that the DBQL logs do not take up space in DBC and impact the system.
- Add a log date to each row. The log date is used as the partitioning column and makes querying the archived data much faster.
- Change the primary indexes. This is done to avoid table skewing.
You can also separate historical data from junk queries to make your DBQL table archives more concise.