Re: Join selectivity is 0 causing bad cardinality estimates.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 12 Dec 2006 22:35:03 -0000
Message-ID: <0_idnbY-AosLs-LYnZ2dnUVZ8ty3nZ2d@bt.com>

<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 - 16:35:03 CST