Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: rule based or cost based?
you can query the v$parameter and look for optimizer_mode. This will show the current default way the optimiser works.
Sateesh Burgadda wrote:
> hi!
>
> I would like to know which optimiser( cost based or rule based)
> is used on my server.
>
> I tried to see init.ora file but nothing found.
>
> Can u help me to know how.
>
> PL reply
> Sateesh
Received on Sun Jan 18 1998 - 00:00:00 CST