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

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

RE: CBO question ?

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Thu, 2 Mar 2006 11:38:54 -0500
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0A189F25@ENYC11P32005.corpny.csfb.com>


If user/all/dba_tables.num_rows is not null, statistics for the table exist. The last_analyzed column tells you when they were gathered.  

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 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




Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 02 2006 - 10:38:54 CST

Original text of this message

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