Re: Density statistic calculation in case of histogram

From: Greg Rahn <>
Date: Mon, 6 Apr 2009 07:42:41 -0700
Message-ID: <>

On Mon, Apr 6, 2009 at 6:56 AM, Neeraj Bhatia <> wrote:
> 2) Without histograms, density should be equal to 1/number of distinct
> values. But in my case, it is null. I am not using method_opt while
> collecting statistics. The global default setting is FOR ALL INDEXED COLUMNS
> SIZE 1.
I would strongly suggest revisiting that METHOD_OPT choice. It is probably one of the worst ones to choose IMO. Here is why:
Greg Rahn
Received on Mon Apr 06 2009 - 09:42:41 CDT

Original text of this message