Chapter 17. SQL Optimization

Throughout this book you find alternate SQL statements for many solutions. This chapter focuses on helping you determine the most effective SQL statement to efficiently and quickly return results. You gain an overview of the workings of the Oracle Optimizer and an understanding of SQL performance tuning techniques. The list of tuning suggestions in this chapter is by no means comprehensive, but merely a starting point. After you understand how to read the execution steps of SQL statements, you will have gained a better understanding of Oracle's optimization strategies and will be able to focus on tuning ...

Get Oracle® SQL by Example, Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.