This discussion is archived
8 Replies Latest reply: Apr 3, 2008 7:14 AM by 591186 RSS

DBMS_STATS.GATHER_TABLE_STATS & DBMS_STATS.GATHER_SCHEMA_STATS

614497 Newbie
Currently Being Moderated
Hi All,

In the GATHER_TABLE_STATS or GATHER_SCHEMA_STATS procedures if for parameter method_opt we use 'FOR ALL INDEXED COLUMNS size skewonly', does this mean we only collect stats for index columns or collect stats for all columns in the table?

Thanks a lot,

Shirley