If "Clear" means "Delete" here, the following may help:

analyze table table_name delete statistics;
-----Original Message-----
From: Puneet Sharma [mailto:[Email Address Removed] Sent: Wednesday, October 30, 2002 10:47 PM
To: LazyDBA.com Discussion
Subject: Clear compute statistics


Hi Guys,

Is it possible to clear the statistics of a table. I have generated stat
for a table by using analyze compute statistics command. Now I want to clear
this stat.

Thanks,
Puneet
Oracle LazyDBA home page