RE: CBO question ?

There can be other triggers too:
CHOOSE will use CBO if *any* one of these is true:

• At least one table in the query has statistics
• A table has CBO-only characteristics:
  • table is an IOT
  • table is partitioned
  • table has parallel degree greater than 1

Also, there may be other triggering events that invoke CBO.....  

-Mark  

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest Information & Learning 

"Exception:  Some dividends may be reported as qualified dividends but
are not qualified dividends.  These include: 

* Dividends you received on any share of stock that you held for less
than 61 days during the 121-day period that began 60 days before the
ex-dividend date.  The ex-dividend date is the first date following the
declaration of a dividend on which the purchaser of a stock is not
entitled to receive the next dividend payment. When counting the number
of days you held the stock, include the day you disposed of the stock
but not the day you acquired it. See the examples below. Also, when
counting the number of days you held the stock, you cannot count certain
days during which your risk of loss was diminished.  See Pub. 550 for
more details."

  --IRS, Form 1040-A Instruction Booklet, Line 9b:  Qualified Dividends 

 

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Igor Neyman
Sent: Thursday, March 02, 2006 11:47 AM
To: Venu.Andem_at_landregistry.gsi.gov.uk; oracle-l_at_freelists.org
Subject: RE: CBO question ?


You are wrong.
 
Igor

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andem, Venu
Sent: Thursday, March 02, 2006 11:41 AM
To: oracle-l_at_freelists.org
Subject: RE: CBO question ?


Paul,
 
I think its the other way round, if one of the tables in the query does
not contain statistics then Oracle uses RBO. pls correct me if i am
wrong.
 
Venu

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Baumgartel, Paul
	Sent: 02 March 2006 15:31
	To: oracle-l_at_freelists.org
	Subject: RE: CBO question ?
	
	
	If any table mentioned in the query has statistics stored in the
data dictionary, Oracle will use the CBO.
	 

	Paul Baumgartel 
	paul.baumgartel_at_credit-suisse.com 
	212.538.1143 

		-----Original Message-----
		From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Savio Pinto (s)
		Sent: Thursday, March 02, 2006 10:28 AM
		To: oracle-l_at_freelists.org
		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 access the attached hyperlink for an important electronic
communications disclaimer: 
	
	http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
	
========================================================================
======

	


	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


--
http://www.freelists.org/webpage/oracle-l