Re: distributions management

On Thu, 03 Jun 2004 16:32:33 -0400, sumGirl wrote: > My company does data mining and we have one very large table that we > probably insert about 1000,000 records a week into and we never remove > records from it. We update stats on this table on a weekly basis, but we do > not drop distributions...my question of course is should I be dropping > distributions? > > I know this is basic, but I cant seem to find a definitive rule of thumb in > the manuals I have access to. > -thanks Update statistics MEDIUM/HIGH drop and recreate the distributions, so youonly have to do a manual DROP DISTRIBUTIONS when you want to revert to LOW stats only and no distributions. Works well for loading huge numbers of new rows (relative to the current count) or new sets of keys. Art S. Kagel

Thanks Art!