O'Reilly logo

Oracle® SQL by Example, Third 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 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 ...

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