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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

EdStevens

This really has nothing to do with SQL Developer (the subject of this forum). It is a much better fit in SQL & PL/SQL.
And just as a side comment, storing 'age' as data is a flawed design. The 'age' of everyone and every thing is increasing by the day, if not by the second. What is your plan to keep 'age' current? Better to store 'date of birth' and the calculate 'age' when needed at run-time.

User_H3J7U

The 'age' of everyone and every thing is increasing by the day, if not by the second.
Sometimes the age stops increasing.
изображение.png

EdStevens

Pour me one!
Of course, that's not actually the age, but the amount of time it was 'aged' in the barrel before bottling.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 2 2013
Added on Apr 1 2013
#general-database-discussions, #index
10 comments
233 views