CHAPTER 8
Maintaining Indexes
Maintaining indexes is always 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.
Collecting optimal index statistics is, of course, a crucial part of index maintenance and so we start with the collection of index statistics. The database sometimes makes an index unusable, following certain index maintenance operations or some error conditions. The chapter explains ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
