Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

Run DBMS_STATS GATHER_SCHEMA_STATS to collect stats for all of your tables and indexes

SQL> SQL> exec dbms_stats.gather_schema_stats(ownname=> USER, cascade=>TRUE , method_opt=>'FOR ALL INDEXED COLUMNS') PL/SQL procedure successfully completed.