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: CBO picks wrong plan after analyze. FIRST_ROWS hint is workaround. ALL_ROWS causes wrong plan

Re: CBO picks wrong plan after analyze. FIRST_ROWS hint is workaround. ALL_ROWS causes wrong plan

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 21 Sep 2006 18:18:35 -0700
Message-ID: <1158887912.741575@bubbleator.drizzle.com>


oracle10_at_gmail.com wrote:
> Thank you Jonathan for reply
>
> I actually only changed column and table names. I didn't remove
> anything. The main thing here is CBO uses small table as driver in
> FIRST_ROWS but not ALL_ROWS.
>
> How do I fabricate stats?
>
> What about bucket size? would it help to say SIZE 20 instead of SIZE 1?
>
> I should read the book first :-)
>
> Thanks

As Jonathan won't say it ... I will. Jonathan's books are an excellent read and an essential resource. You'll not find a better use of your time (Oracle-wise).

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Thu Sep 21 2006 - 20:18:35 CDT

Original text of this message

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