Gather information about all columns
Gather information about indexed columns
exec dbms_stats.gather_table_stats ( - '&&owner', '&&table_name' - ,estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE - ,block_sample => true - ,granularity => 'all' - ,method_opt => 'for all columns size auto' - ,cascade => true)
Gather information about indexed columns
exec dbms_stats.gather_table_stats ( - '&&owner', '&&table_name' - ,estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE - ,block_sample => true - ,granularity => 'all' - ,method_opt => 'for all indexed columns size auto' - ,cascade => true)