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