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