Re: best statistic target for boolean columns

Gaetano,

> don't you think the best statistic target for a boolean
> column is something like 2?  Or in general the is useless
> have a statistics target > data type cardinality ?

It depends, really, on the proportionality of the boolean values; if they're
about equal, I certainly wouldn't raise Stats from the default of 10.   If,
however, it's very dispraportionate -- like 2% true and 98% false -- then it
may pay to have better statistics so that the planner doesn't assume 50%
hits, which it otherwise might.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco