| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to discard the statistics on tables and indexes?
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of chuan.zhang_at_customs.gov.au
Sent: Wednesday, March 24, 2004 9:47 PM
To: oracle-l_at_freelists.org
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.
 |
 |