RelationalDBDesign RelationalDBDesign 


Partitioned Tuning   «Prev 

Consider Costs and Benefits of Coalescing or Rebuilding Indexes

Improper sizing or increased growth can produce index fragmentation. To eliminate or reduce fragmentation, you can rebuild or coalesce the index. But before you perform either task weigh the costs and benefits of each option and choose the one that works best for your situation.
Table 5-6 is a comparison of the costs and benefits associated with rebuilding and coalescing indexes

Table 5-6 Costs and Benefits of Coalescing or Rebuilding Indexes

Costs and Benefits of Coalescing or Rebuilding Indexes

Oracle index rebuild

ALTER INDEX DATE_IDX REBUILD PARTITION 2009_IDX
TABLESPACE TS_2009_IDX
We issue the alter index command to rebuild the partition

ALTER INDEX DATE_IDX REBUILD PARTITION 2009_IDX
 TABLESPACE TS_2009_IDX
The 1998 and 2000 indexes may still service queries while the 1999 index is being built.