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 11

image

SQL Optimization Techniques

Whenever the query optimizer is unable to automatically generate an efficient execution plan, some manual optimization is required. For that purpose, Oracle Database provides several techniques, summarized in Table 11-1. The goal of this chapter isn’t only to describe these techniques in detail but to explain what each technique can do for you and in which situations you can take advantage of them. To choose one of them, it’s essential to ask yourself three basic questions:

  • Is the SQL statement known and static?
  • Should the measures to be taken have an impact on a single SQL statement or on all SQL statements ...

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