-
Index rebuilding
At what point do we decide that it's time to start rebuilding the tables indexes? I have max_extents set to UNLIMITED on both tables and indexes. Some of the indexes have grown to more than 100 extents but I don't see any visible performance degradation. But I am not sure when should I start thinking about rebuilding my indexes or do an import / export on tables to reset extents. Any help is greatly appreciated. Thx. Sathya
-
If you are using locally managed tablespaces, instead of the old dictionary management, then you have a long way to go before you start to see degradation -- 1,000 extents is entirely manageable.
-
Originally Posted by sathya_jonnalag
At what point do we decide that it's time to start rebuilding the tables indexes?
When someone puts a gun to your head and makes you do it.
You should really read the following, HOW TO STOP DEFRAGMENTING AND START LIVING: THE DEFINITIVE WORD ON FRAGMENTATION.
-
Search "rebuild indexes" on Asktom.oracle.com for reasons not to rebuild
"False data can act only as a distraction. Therefore. I shall refuse to perceive you." - Bomb #20
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|