O'Reilly logo

Troubleshooting Oracle Performance, Second Edition by Christian Antognini

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 9

image

Configuring the Query Optimizer

The query optimizer is directly responsible for the performance of SQL statements. For this reason, it makes sense to take some time to configure it correctly. In fact, without an optimal configuration, the query optimizer may generate inefficient execution plans that lead to poor performance.

The configuration of the query optimizer consists not only of several initialization parameters but also of system statistics and object statistics (system and object statistics are described in Chapter 7 and Chapter 8, respectively). This chapter describes how these initialization parameters and statistics influence ...

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