[Email Address Removed] wrote:

>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 documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
analyze table table_name delete statistics should work.

--
hope this helps.
Stan



Oracle LazyDBA home page