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: Default optimizer_index_caching value DUMB ...

Re: Default optimizer_index_caching value DUMB ...

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 06 Nov 2004 19:21:35 +0800
Message-ID: <418CB3BF.2FA5@yahoo.com>


Jonathan Lewis wrote:
>
> Note in-line.
>
> --
> Regards
>
> Jonathan Lewis
>
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> The Co-operative Oracle Users' FAQ
>
> http://www.jlcomp.demon.co.uk/seminar.html
> Optimising Oracle Seminar - schedule updated Sept 19th
>
> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
> news:1099668063.964495.137880_at_z14g2000cwz.googlegroups.com...
> >
> > A relevant metalink note (62286.1) would suggest that Oracle intend the
> > value to be considered for in-list as well as NL.
> >
>
> Amazing - there is a similar reference for optimizer_index_cost_adj.
> They both went public in 8.0.5 ! If you'd asked me cold, I would
> have sworn they didn't appear until 8.1.

definitely 8.0 (used with some success at a UK client back in '99)

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------
Received on Sat Nov 06 2004 - 05:21:35 CST

Original text of this message

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