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
