Scott,
> But possible more error prone. If you crank up the default statistics to
> 50, but the index default is still 25... OTOH, you could always have the
> setting of used for index default be whichever is greater... hmmm.
Well, I'm not 100% opposed to a multiplier. I'd like to take a poll of DBAs
to find out which they would find more accessable. But since most people
seem to be ignoring this thread, I'm not sure we'll get much response ...
--
-Josh BerkusAglio Database SolutionsSan Francisco