Toad World® Forums

Plan Control

SQL Optimizer SQL Optimizer for Oracle
#1

Hello ,

I need to know when I use plan control to optimize excustion plan and deploy the best alternative to be plan baseline.

this mean that when we run this SQL statement in oracle database from toad, automatic the excustion plan which we deploy it before or what will happen?

Thanks

#2

Hi,

By default, SQL Optimizer deploys a SQL Plan Baseline with the FIXED attribute. So once you have deployed it, Oracle will automatically use your deployed plan. In other words, if you run your SQL in Toad or get plan there, your deployed plan should be effective. Anything should be automatic unless you have turn off the OPTIMIZER_USE_SQL_PLAN_BASELINES initialization parameter.

Thanks,

Alex