CHAPTER 7
Tuning Index Usage
In order to tune index usage, it is important to understand the various types of index access paths available to the cost optimizer. The 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 optimizer might prefer a full table scan to using an index. You'll also learn how to force the optimizer to use (or not to use) an index. Oracle provides a large number ...
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.
