Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 9i 'optimizer_goal'
Can anyone confirm on a non-Win2K 9i platform?
SQL> alter session set optimizer_mode = first_rows_1;
Session altered.
SQL> alter session set optimizer_goal = first_rows_1; alter session set optimizer_goal = first_rows_1
*
Yet - from the doco -
"The OPTIMIZER_GOAL parameter can have the same values as the
OPTIMIZER_MODE initialization parameter"
Cheers
Connor
-- ============================== Connor McDonald http://www.oracledba.co.ukReceived on Tue Nov 13 2001 - 08:54:25 CST
"Some days you're the pigeon, some days you're the statue..."