Re: FOR ALL INDEXED COLUMNS SIZE 254

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 13 Sep 2011 14:18:16 +0000 (UTC)
Message-ID: <pan.2011.09.13.14.18.16_at_gmail.com>

On Tue, 13 Sep 2011 02:03:14 -0700, Randolf Geist wrote:

> - Use FOR ALL COLUMNS SIZE 1 as default. This way you ensure that you
> end up with basic column statistics on all columns. - Generate
> histograms only on columns where you can prove that it will be
> beneficial - do this explicitly or you could use an approach of SIZE
> REPEAT instead of SIZE 1 and generate the histogram once explicitly
> - There are cases where you will only benefit from a histogram when
> crafting it manually
>
> Hope this helps,
> Randolf

This is an interesting suggestion which doesn't waste too much space. I will try it out and will let you know of the outcome.

-- 
http://mgogala.byethost5.com

Received on Tue Sep 13 2011 - 09:18:16 CDT