18. Designing and Monitoring Indexes for Optimal Performance
There is an old saying among carpenters: “If the only tool you have is a hammer, everything starts to look like a nail.” Likewise, a properly chosen and deployed index can be one of the most flexible and sharpest tools in an Oracle DBA’s toolbox, as long as the DBA realizes that an index is not the only tool that may be appropriate for solving query performance issues.
This chapter discusses the different types of indexes that are available for Oracle databases, as well as each index type’s strengths and weaknesses. This chapter also looks at issues that can typically arise when indexes are misused or overused in an Oracle database and how to detect when this is the case. New features ...
Get Oracle Database Problem Solving and Troubleshooting Handbook 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.
