RE: How to discard the statistics on tables and indexes?
- From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Mar 2004 22:11:12 -0700
I'm not sure what you're asking here...
Seeing what's going on with the CBO without statistics is a bit like asking
what's going on with your car without all that gasoline getting in the way.
You can discard statistics with dbms_stats.delete_table_stats,
delete_schema_stats, or delete_database_stats, but that will cause Oracle to
revert to the rule-based optimizer for most queries. When a query requires the
use of the CBO, it will have to make what are essentially guesses as to the
table composition in the absence of statistics.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of chuan.zhang@xxxxxxxxxxxxxx
Sent: Wednesday, March 24, 2004 9:47 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: How to discard the statistics on tables and indexes?
Hi, All,
Our database is CBO based. I would like to see what's going on without those
collected statistics on tables and indexes. Is there any way to discard these
collected statistics?
TIA,
Important: This transmission is intended only for the use of the addressee and
may contain confidential or legally privileged information. If you are not the
intended recipient, you are notified that any use or dissemination of this
communication is strictly prohibited. If you receive this transmission in
error please notify the author immediately by telephone and delete all copies
of this transmission together with any attachments.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe'
in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
