Hello Sweetie

The OPTIMIZER_GOAL parameter of the ALTER SESSION statement can override the optimizer approach and goal established by the OPTIMIZER_MODE initialization parameter for an individual session.

The value of this parameter affects the optimization of SQL statements issued by stored procedures and functions called during the session, but it does not affect the optimization of recursive SQL statements that Oracle issues during the session.

so the answer to your question is YES.

i just reread the entire discussion here.

in the firs thread you asked me this .

I read from a book that by default oracle uses choose and first_rows, is this true

and the answer is yes.if you select a OLTP database oracle uses first_rows .

you can refer to Oracle sql high performance tuning by guy harrison.

regards
Hrishy