RE: CBO question ?
- From: "Andem, Venu" <Venu.Andem@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <spinto@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 2 Mar 2006 15:31:39 -0000
CHOOSE 'IS' CBO
pls read at <http://tahiti.oracle.com/> http://tahiti.oracle.com, perf tuning
guide.
-Venu
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Savio Pinto (s)
Sent: 02 March 2006 15:28
To: oracle-l@xxxxxxxxxxxxx
Subject: CBO question ?
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
PLEASE NOTE: THE ABOVE MESSAGE WAS RECEIVED FROM THE INTERNET.
On entering the GSi, this email was scanned for viruses by the Government
Secure Intranet (GSi) virus scanning service supplied exclusively by Cable &
Wireless in partnership with MessageLabs.
Please see http://www.gsi.gov.uk/main/notices/information/gsi-003-2002.pdf for
further details.
In case of problems, please call your organisational IT helpdesk
Land Registry at Homebuyer Show, 17-19 March, ExCeL London
If you have received this e-mail and it was not intended for you, please let us
know, and then delete it. Please treat our information in confidence, as you
would expect us to treat yours.The Land Registry checks all mail and
attachments for known viruses, however, you are advised that you open any
attachments at your own risk.
The original of this email was scanned for viruses by the Government Secure
Intranet (GSi) virus scanning service supplied exclusively by Cable & Wireless
in partnership with MessageLabs.
On leaving the GSi this email was certified virus-free
Other related posts:
