Oracle optimizer - Dec 03, 2008 at 15:00 PM by Rajmeet Ghai
Explain how oracle optimizer works.
Oracle optimizer determines the best possible way to execute a query. This
optimizer uses internal set of rules or costing methods to ace hove the result.
The output from the optimizer is a plan that describes an optimum method of
execution the optimizer first evaluates expressions and conditions containing
constants as fully as possible. Here after it chooses either a cost-based or
rule-based approach and determines the goal of optimization. For each table
accessed it chooses one access path from the available ones.
The answers to following questions will be made
available soon. Keep visiting.
Explain how oracle optimizer works.
Explain optimization methods, i.e. cost-based approach, rule-based
optimization.
|