RE: 54 is less than 4 for CBO ?
- From: "Milen Kulev" <makulev@xxxxxxx>
- To: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- Date: Mon, 22 May 2006 17:19:25 +0200 (MEST)
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@xxxxxxxxxxxx>
> An: "Milen Kulev" <makulev@xxxxxxx>
> Kopie: <oracle-l@xxxxxxxxxxxxx>
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
