> 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 Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to