Collect statistics
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
Three different methods
Plain analyze command
analyze table table_name compute statistics;
Schema level analyze using DBMS_UTILITY.ANALYZE_SCHEMA
execute DBMS_UTILITY.ANALYZE_SCHEMA('EMPI', 'ESTIMATE')