Re: Update Statistics

Andrew Ford said: >> > 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? 1. They get out of date. 2. They take up space. > ----- 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. >> > > -- 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