On 11/12/13 19:34, Simon Riggs wrote:
>
> Realistically, I never heard of an Oracle DBA doing advanced
> statistical mathematics before setting the sample size on ANALYZE. You
> use the default and bump it up if the sample is insufficient for the
> data.
>
I'm not sure that Oracle's stats and optimizer design is an example to
be envied - pretty much all Oracle DBA's I've encountered will apply
hints all queries to get the plan they want...
Regards
Mark