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: Join selectivity is 0 causing bad cardinality estimates.

Re: Join selectivity is 0 causing bad cardinality estimates.

From: EscVector <Junk_at_webthere.com>
Date: 12 Dec 2006 19:59:28 -0800
Message-ID: <1165982368.461004.158090@f1g2000cwa.googlegroups.com>


So I'm guessing the answer would be, "No, it makes no sense..." :)

Jonathan Lewis wrote:
> <andrew.markiewicz_at_gmail.com> wrote in message
> news:1165962649.719151.162500_at_16g2000cwy.googlegroups.com...
> > We also have histograms calculated using a similar method as you have,
> > FOR ALL COLUMNS SIZE AUTO.
> >
>
> That's your main problem.
>
> You don't need histograms on all columns,
> and you don't want to let Oracle work out
> the details.
>
>
> --
> Regards
>
> Jonathan Lewis
> http://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentals
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Received on Tue Dec 12 2006 - 21:59:28 CST

Original text of this message

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