Oracle Tables Analyze job for DWH database

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

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? 

Environment

Release : Any

Resolution

• 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.