O'Reilly logo

Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database by Bill Padfield, Sam R Alapati, Darl Kuhn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Darl Kuhn, Sam R Alapati and Bill Padfield, Expert Oracle Indexing and Access Paths, 10.1007/978-1-4842-1984-3_8

8. Maintaining Indexes

Darl Kuhn, Sam R. Alapati2 and Bill Padfield3

(1)Morrison, Colorado, USA

(2)Flower Mound, Texas, USA

(3)Aurora, Colorado, USA

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.

Collecting optimal index statistics is, of course, a crucial part of index maintenance, and so we start with the collection ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required