To optimize the performance of the query engine, refresh statistics by running stored procedure REFRESH_STATS_TAB.
Execute this procedure:
After the initial CDM data load.
After any significant changes in data volumes or distribution in the CDM schema.
Periodically.
To execute the procedure:
On the database server, log in to SQL*Plus as CDM.
Execute the following commands:
set serveroutput on set echo on spool REFRESH_STATS_TAB execute REFRESH_STATS_TAB spool off exit