Forum Stats

  • 3,770,135 Users
  • 2,253,074 Discussions
  • 7,875,339 Comments

Discussions

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

user4295847
user4295847 Member Posts: 102 Blue Ribbon
edited Apr 4, 2013 6:30AM in General Database Discussions
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
Tagged:

Best Answer

Answers

This discussion has been closed.