RE: CBO question ?

From: "Jim Silverman" <jsilverman@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 2 Mar 2006 11:39:51 -0500
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@xxxxxxxxxxxxx 

                From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Savio Pinto (s)
                Sent: Thursday, March 02, 2006 11:32 AM
                To: paul.baumgartel@xxxxxxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
                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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Baumgartel, Paul
                Sent: Thursday, March 02, 2006 9:31 AM
                To: oracle-l@xxxxxxxxxxxxx
                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@xxxxxxxxxxxxxxxxx 
                212.538.1143 
                -----Original Message-----
                From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Savio Pinto (s)
                Sent: Thursday, March 02, 2006 10:28 AM
                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 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)
RE: CBO question ?

Other related posts:
