Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> CBO question ?

CBO question ?

From: Savio Pinto (s) <spinto_at_cap.org>
Date: Thu, 2 Mar 2006 09:27:30 -0600
Message-ID: <65C8A9E504AAAB4FB670DAB8DBF8A2CC013342DE@vulcan.cap.org>


Hi,

The execution plan for a query in oracle 9i shows "Optimizer= CHOOSE", how can i force the DB engine to use the COST based optimization for a query ?

Oracle version is 9.2.0.4.0

Thanks
Savio Pinto

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 02 2006 - 09:27:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US