Re: RULE vs CHOOSE

Roy Klassen wrote:
>
> If heard that if you sset your optimizer mode to FIRST ROWS, this will
> speed thing up.
>
> I'm going to try it on my databases and see if it works.
>
> They said that CHOOSE favours more full table scans than FIRST ROWS.
>
> Try and let me know what happens!!!
>
> Roy Klassen rklassen_at_pei.sympatico.ca
>
> Business Information Services <email_at_bisinfo.com.au> wrote in article
> <MPG.e590c7723a1d3f1989681_at_nsw-newshost.tpgi.com.au>...
> > Hi,
> >
> > Probably another stupid question ... :-)
> >
> > If the database tables are never analysed is there any point in having
> > the OPTIMISER set to CHOOSE (the default) and in fact would it slow
> > things down? I mean I don't know what happens in the bowels of Oracle but
 

> > I'd say it would probably spend some superfluous time searching for table
 

> > statistics before using rules.
> >
> > Any thoughts appreciated.
> >
> > Rowan McCammon.
> >

We use Oracle 7.3 on an HpUx. Usually Rule will give better performance while retrieving data!

-- 
Ronny Ivarsen
ivarsen_at_online.no