From: Mladen Gogala <>
Date: Tue, 13 Sep 2011 14:18:16 +0000 (UTC)
Message-ID: <>

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.

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

Original text of this message