Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: optimizer mode
"Imprecise" <f_puhan_at_precise.com> ha scritto nel messaggio
news:f_puhan-A93D69.08155017062002_at_vienna7.his.com...
> In article <9dkP8.27091$j65.659586_at_twister1.libero.it>,
> "Mark" <mbwn_at_inwind.it> wrote:
>
> > The data was moved
> > from 8.1.7 to 8.05 and from 8.05 to 7.3.4
> > why the optimizer_mode =RULE is ignored?
>
> What does your explain plan show you?
>
show me a cost other than 0,
show me a lot of full scans
even if there are the right indexes
if i compute statistics all is ok
Received on Mon Jun 17 2002 - 07:24:11 CDT