How to change Optimizer goal from Rule base to Cost Based

[Sanjay]

Hi All,

How to change Optimizer goal from Rule base to Cost Based in PL/SQL developer.

Thanks & Regards
Sanjay

 

[Benjamin L]

Hi Sanjay,

when you entered your SQL (in SQL-Window) you can Press F5 (Tools/Explain Plan), and there is a Drop-Down List where you can choose the optimizer Goal.
In SQL you can do this with hints. But if youre Oracle Version is higher then 9 i wouldn't use this. Oracle hints are depricated since 10g in my opinion. Cause the internal optimizers works in other ways then before.

Benjamin

 

[Sanjay]

Thanks Benjamin for the answer

Thanks & Regards
Sanjay

 

[William Robertson]

If it's set at the instance level then you need to look at ALTER SYSTEM.