Oracle Tables Analyze job for DWH database
Article ID: 251753
Clarity PPM On Premise
Clarity PPM SaaS
The Clarity niku schema has an Oracle Tables Analyze job to help performance. Should we also be analyzing the DWH database (ppm_dwh) or running any statistics?
- The analyze job SP also exists on the DWH database, it's called CMN_JOB_ANALYZE_SP.
- You don't have to schedule it separately
- The Load Data Warehouse job will run it as part of DWH_CFG_POST_CONFIG_SP at the end of each Load DWH run, after inserting the data. It would recalculate everything.