O'Reilly logo

Oracle® SQL by Example, Fourth Edition by Alice Rischert

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required