Oracle Gather Stats
Gather Database Stats EXEC dbms_stats.gather_database_stats; /* Gather Database Stats with default preference */ EXEC dbms_stats.gather_database_stats(cascade=>true,method_opt=>'FOR ALL COLUMNS SIZE AUTO'); EXEC DBMS_STATS.gather_database_stats(estimate_percent => dbms_stats.auto_sample_size, degree=>