Re: Performance Problem

From: "Art S. Kagel" <kagel@bloomberg.net> > >HOW do you run update stats? Do you use the recommended suite of commands >for each table? Or do you just UPDATE STATISTICS; at the database level >with no options? Makes a BIG difference. Well, now -- it's funny you should say this, but I've been chanting that mantra for ages. Then a particularly opinionated chap in Informix Advanced Technology assured me that medium and high were often only useful in SAP sites or sites of that ilk, and that careful consideration should be given to evaluating and comparing the performance gains of an USL vs USM or USH. He didn't say it in quite those words, of course, but the bruises are subsiding... :-) And in this particular case, he was proven right, because he got much better performance with a given query than I could. So it might make a big difference, just not the one you want. :) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com