Maintaining Indexes

  • Darl Kuhn
  • Sam R. Alapati
  • Bill Padfield


Maintaining indexes is a big part of an Oracle DBA’s workload. There are many aspects to maintaining indexes, and often there are multiple ways to achieve the same goals. This chapter explains several key aspects of index maintenance to help you improve the performance of your indexes and to efficiently manage index space usage.


Execution Plan Free List Index Block Large Block Size Index Creation 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Darl Kuhn, Sam R. Alapati and Bill Padfield 2016

Authors and Affiliations

  • Darl Kuhn
    • 1
  • Sam R. Alapati
    • 2
  • Bill Padfield
    • 3
  1. 1.MorrisonUSA
  2. 2.Flower MoundUSA
  3. 3.AuroraUSA

Personalised recommendations