Re: Update statistics performance

Guido Jimenez M. said: > Hi Friends (again) .! > > I wonder if I perform a "update statistics" statement will decrease the > performance of my server? I have HP-UX rx5670 B.11.23 U ia64 3861480093 > unlimited-user license . This Company works 24 hours a day, and from the > 12:00 AM to 06:00 AM the activities are low. > What you advise to me ? You need to run a series of UPDATE STATISTICS commands regularly to give the optimiser info so that it can perform at, well, an optimal level. Check out Art Kagel's excellent dostats utility from the iiug.org website. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco Travel broadens a person. You look as if you have been all over the world. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed http://i2.photobucket.com/albums/y41/Obnoxio/thinkIfoundtheproblem.jpg sending to informix-list