How to discard the statistics on tables and indexes?
- From: chuan.zhang@xxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 25 Mar 2004 15:47:26 +1100
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
-----------------------------------------------------------------
Other related posts:
