how about "analyze table table_name drop statistics"...

[Email Address Removed] Original Message -----
From: "Puneet Sharma" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Wednesday, October 30, 2002 9:46 PM
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