Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: optimizer mode
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?
> "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:15:50 CDT