Generating the Database Statistics

Ideally, you must gather the statistics for all tables whose partitions are dropped and indexes are rebuilt.

Procedure

To generate the database statistics for an individual table:

Execute the following statement:

BEGIN
DBMS_STATS.GATHER_TABLE_STATS(OWNNAME=>'CISADM', TABNAME=>'<Table_Name>', GRANULARITY=>'ALL', CASCADE=>TRUE, METHOD_OPT=> 'FOR ALL COLUMNS SIZE AUTO', DEGREE=>32);
END;