Re: Update Statistics

> > What would I gain by dropping distributions? I always thought old > > And not rebuilding them? You gain the time needed for the US MEDIUM and US > HIGH. :o) But the whole point of running update statistics high or medium is to generate distributions? Especially when run with the distributions only syntax because you've previously collected statistics from an update stats low. > Yes, but what if you don't need distributions *at all*? I agree that there are instances when you do not need distributions. If they already exist what is the harm of keeping them around? Andrew ----- Original Message ----- From: "Obnoxio The Clown" <obnoxio@serendipita.com> To: "Andrew Ford" <andrewford@austin.rr.com> Cc: "Obnoxio The Clown" <obnoxio@serendipita.com>; <informix-list@iiug.org> Sent: Thursday, June 09, 2005 12:16 PM Subject: Re: Update Statistics > > Andrew Ford said: > >> Have you considered just doing UPDATE STATISTICS LOW FOR TABLE xxx DROP > >> DISTRIBUTIONS? You don't always need the distributions. > >> > >> It's worth trying, anyway. > > > > I haven't. But that's not really what I'm trying to get at. I'm happy > > with > > the final result of dostats and am not experiencing any performance > > problems. I'm just interested in getting the same results more > > efficiently. > > > > What would I gain by dropping distributions? I always thought old > > And not rebuilding them? You gain the time needed for the US MEDIUM and US > HIGH. :o) > > > distributions were better than no distributions if the nature of your data > > set hasn't changed drastically. > > Yes, but what if you don't need distributions *at all*? > > -- > > Bye now, > Obnoxio > > "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" > - Coluche > > A smile is a gift that is free to the giver and precious to the recipient. > But giving someone the finger is free too, and I find it more personal and > sincere. > sending to informix-list