Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 54 is less than 4 for CBO ?
Hi Chris,
you are right.
After using first_rows(1) as hint the CBO
took into account the hint (clearly seen in 10053 trace file).
Thanks again.
Regards. Milen
> --- Ursprüngliche Nachricht ---
> Von: "Christian Antognini" <Christian.Antognini_at_trivadis.com>
> An: "Milen Kulev" <makulev_at_gmx.net>
> Kopie: <oracle-l_at_freelists.org>
> Betreff: RE: 54 is less than 4 for CBO ?
> Datum: Mon, 22 May 2006 16:58:08 +0200
>
> 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
>
-- Echte DSL-Flatrate dauerhaft für 0,- Euro*! "Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl -- http://www.freelists.org/webpage/oracle-lReceived on Mon May 22 2006 - 10:19:25 CDT
![]() |
![]() |