Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_STATS.GATHER_TABLE_STATS & DBMS_STATS.GATHER_SCHEMA_STATS

614497Apr 1 2008 — edited Apr 3 2008
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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 1 2008
Added on Apr 1 2008
8 comments
53,513 views