Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: optimizer mode
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?
"Imprecise" <f_puhan_at_precise.com> ha scritto nel messaggio
news:f_puhan-9F7952.16264716062002_at_vienna7.his.com...
> In article <eM5P8.24766$j65.597564_at_twister1.libero.it>,
> "Mark" <mbwn_at_inwind.it> wrote:
>
> > I imported a db schema to a 7.3.4 db and the optimizer don't do what i
want.
> > I used a rule-based optimizer mode, and i told that on the init*.ora. I
> > tried deleting statistics with
> > ANALYZE TABLE table DELETE STATISTICS;
> > I tried rebuilding indexes
> > but it doesnt like to use the index as it usually do in the other
schema.
> >
> > Is there something wrong?
>
> Not enough data to answer. From what version did you import? Did you
> go 8/9.x -> 7.3.4 or 7.x -> 7.3.4? The optimizer has changed over
> version releases, so results may be unpredictable.
>
> --
> The underscore character does not belong in my address. You know the
drill...
> ***
> Anyone sufficiently smart enough to configure and use USEnet for research
should
> be smart enough to Read The Freakin' Documentation!
Received on Mon Jun 17 2002 - 07:02:13 CDT