Summary
This chapter started off with a discussion of the various types of index access paths, such as a fast full scan and an index range scan, and their implications. You also learned under what conditions the optimizer might select various index access paths. On occasion, it may better to force a full table scan for some queries and this chapter showed you how to do that. This chapter discussed several reasons why the optimizer may not choose to use an index and how you can use various strategies to influence the optimizer's choice of an index. Finally, this chapter showed you how to parallelize index access and how to specify the parallel option when creating an index.
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.
