RE: CBO question ?

From: Jim Silverman <jsilverman_at_Solucient.com>
Date: Thu, 2 Mar 2006 11:39:51 -0500
Message-ID: <2D1EFB433A527D4681B80C94B71E359804239AE2@aaexchange01.HEALTH.AD>

Issue the statement

        select table_name, last_analyzed from user_tables;

If the last_analyzed column is not null, statistics exist (although they may not be up to date); if it is null, statistics do not exist. Of course, you could also query the all_tables and/or dba_tables views, as appropriate.

---

Jim Silverman
Senior Systems Database Administrator
Solucient, LLC
Telephone: 734-669-7641

FAX:            734-930-7611 
E-Mail:         jsilverman_at_solucient.com 

		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 11:32 AM
		To: paul.baumgartel_at_credit-suisse.com;
oracle-l_at_freelists.org
		Subject: RE: CBO question ?

		Thanks, but how can i check/verify that the statistics
are stored for a particular table in the data dictionary ? 
		-----Original Message-----
		From: oracle-l-bounce_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Baumgartel, Paul

		Sent: Thursday, March 02, 2006 9:31 AM
		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         

---

---

This message is a private communication. It may contain information that is confidential and legally protected from disclosure. If you are not an intended recipient, please do not read, copy or use this message or any attachments, and do not disclose them to others. Please notify the sender of the delivery error by replying to this message, and then delete it and any attachments from your system. Thank you,
Solucient LLC
(eXclaimer 4x)

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

Received on Thu Mar 02 2006 - 10:39:51 CST