Re: drop a histogram on a single column
From: Greg Rahn <greg_at_structureddata.org>
Date: Mon, 15 Dec 2008 10:02:35 -0800
Message-ID: <a9c093440812151002r514ff159q9d777db64a09dc39@mail.gmail.com>
Date: Mon, 15 Dec 2008 10:02:35 -0800
Message-ID: <a9c093440812151002r514ff159q9d777db64a09dc39@mail.gmail.com>
On Mon, Dec 15, 2008 at 8:44 AM, kyle Hailey <kylelf_at_gmail.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 15 2008 - 12:02:35 CST