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

Home -> Community -> Usenet -> c.d.o.server -> Re: optimizer mode

Re: optimizer mode

From: Imprecise <f_puhan_at_precise.com>
Date: Mon, 17 Jun 2002 08:15:50 -0400
Message-ID: <f_puhan-A93D69.08155017062002@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?  

> "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

Original text of this message

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