Re: drop a histogram on a single column

  • From: "Greg Rahn" <greg@xxxxxxxxxxxxxxxxxx>
  • To: kylelf@xxxxxxxxx
  • Date: Mon, 15 Dec 2008 10:02:35 -0800

On Mon, Dec 15, 2008 at 8:44 AM, kyle Hailey <kylelf@xxxxxxxxx> wrote:
> Anyone know a way to drop a histogram on single column?

Version >= 10.2.0.4
dbms_stats.delete_column_stats(..., col_stat_type=>'HISTOGRAM');

-- 
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l


Other related posts: