Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 54 is less than 4 for CBO ?

RE: 54 is less than 4 for CBO ?

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Mon, 22 May 2006 16:58:08 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF3F5CD7@MSXVS04.trivadis.com>


Milen

> I have tried with first_rows_10 and first_rows_1 ( first_rows_10) or the
>optimizer is still using the old execution plan (first FTS on T_FZG_SA
>table). The interesting part is that using hint FIRST_ROWS_1 the CBO
>doesn't even try to recalculated the cost (effectively ignoring the hint)

I'm sorry, I gave you a partially wrong information :-(

The problem is, with the new first row optimizer, that the INIT.ORA parameter takes as values FIRST_ROWS_n but the hint has the form FIRST_ROWS(n).

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 22 2006 - 09:58:08 CDT

Original text of this message

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