Chapter 18. SQL Optimization

Throughout this book, you have seen alternate SQL statements for many solutions. This chapter focuses on helping you determine which SQL statement will most efficiently and quickly return results. It provides an overview of the workings of the Oracle optimizer and describes SQL performance tuning techniques. The list of tuning suggestions in this chapter is by no means comprehensive but merely a starting point. When 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 problem ...

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

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