To tune index usage , it’s important to understand the various types of index access paths available to the cost optimizer. This chapter summarizes the most important index access paths available to the optimizer. Often, Oracle database administrators are bewildered when the optimizer chooses not to use what they believe is a very useful index, but does a full table scan instead. This chapter devotes attention to exploring some reasons why the ...
© 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_7
7. Tuning Index Usage
Darl Kuhn1 , Sam R. Alapati2 and Bill Padfield3
(1)Morrison, Colorado, USA
(2)Flower Mound, Texas, USA
(3)Aurora, Colorado, USA
Get Expert Oracle Indexing and Access Paths: 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.
