Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Default optimizer_index_caching value DUMB ...
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
![]() |
![]() |