RE: 54 is less than 4 for CBO ?

From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
To: "Milen Kulev" <makulev@xxxxxxx>
Date: 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

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: 54 is less than 4 for CBO ?
From: Milen Kulev

RE: 54 is less than 4 for CBO ?

Other related posts: