CHAPTER 5

image

Introduction to Tuning

This chapter introduces the first of the two major themes of this book: tuning a SQL statement. The systematic process described in this chapter is designed to identify an approach to the execution of a SQL statement that ensures that the SQL statement runs in a reasonable amount of time without undue consumption of resources. At this stage I am just going to give you an overview of the process. I will go into a lot more detail in Part 4 of this book.

It is important to understand that the techniques used to identify the approach to getting a SQL statement to run fast may be different from the techniques used ...

Get Expert Oracle SQL now with O’Reilly online learning.

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