SQL Optimization Techniques

  • Christian Antognini


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:


Initialization Parameter Access Structure Execution Environment Execution Plan Query Optimizer 

Copyright information

© Christian Antognini 2014

Authors and Affiliations

  • Christian Antognini
    • 1
  1. 1.Monte CarassoSwitzerland

Personalised recommendations