* Josh Berkus <josh@agliodbs.com> [081202 15:54]:
> Do you have any idea how skewed the distribution of data for DBT3 is? If
> values are being generated in relatively equal proportion, I'd expect
> increasing DST to have little effect. The databases where higher DST is
> useful is ones with skewed data distribution.
>
> Unfortunately, all the data examples I could point to are proprietary
> customer databases :-(
But no body's asking anybody to point out "skewed" data... I think it's
*unanimous* that on skewed data, a higher stats target is needed for the
skewed columns.
The question is how much of a penalty the (majority of?) users with "normal"
data columns will have to pay in stats/planning overhead to accomidate a
blanket increase in DST for the (few?) skewed columns.
I think Marks started to try and show that overhead/difference with real
numbers.
My (probably unsubstantiated) bias is showing, but nobody else has (yet)
showed otherwise ;-)
a.
--
Aidan Van Dyk Create like a god,
aidan@highrise.ca command like a king,
http://www.highrise.ca/ work like a slave.