Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: rule based or cost based?

Re: rule based or cost based?

From: Peter Verhaegen <peter.verhaegen_at_mace.be>
Date: 1998/01/18
Message-ID: <34C23A23.AFDAAA1@mace.be>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US