Skip to Main Content
Forums

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!

Collecting Stats in oracle 9i

647528Jun 30 2008 — edited Jul 1 2008
What is better way to collect stats on table ?

Analyze table compute stats

DBMS_STATS.Gather tablestats

if new index is added to table
stats should be collected on the whole table or else only on that index.(analyze or DBMS ?) which is added

Can anyone tell that what precautions should be taken before collecting stats for added index on the table

As wrong stats will have lot of performance issues

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2008
Added on Jun 30 2008
#general-database-discussions
6 comments
3,040 views