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