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!

Index Rebuild VS analyze index-compute statics VS DBMS_STATS.GATHER_INDEX_S

user4295847Apr 1 2013 — edited Apr 4 2013
Hi ,

I have little doubt on below listed topics. Please explain me each topics and when we need to use for same. Can I use these all at a time ? WHat are advantages and disadvantages forthese topics ?

1) Index Rebuild and index rebuild online
2) analyze index-compute statics and validate strcture
3) DBMS_STATS.GATHER_INDEX_STATS
This post has been answered by Fran on Apr 4 2013
Jump to Answer

Comments

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

Post Details

Locked on May 2 2013
Added on Apr 1 2013
10 comments
239 views