Summary
This chapter explained some of the most common index maintenance operations. You learned how to collect statistics for indexes. In this connection, it's important to specify correct values for the METHOD_OPT parameter and this chapter explained how to do this. Rebuilding indexes is often a troublesome part of index maintenance due to the many arguments for and against regular index rebuilds. The chapter discusses both arguments and explains why an automatic rebuild of indexes may really be unnecessary. The chapter also explains shrinking and coalescing operations and offered guidelines as to when these operations are appropriate. The chapter explained when Oracle makes an index unusable and how to deal with it. You also learned how to ...
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.
