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