unsubscribe

"ART KAGEL, ...." <kagel@bloomberg.net> wrote: Uday: Your server version, though a bit old, has the latest internal update statistics and sorting optimizations. You should be doing the following to produce useful levels of stats while minimizing stats collection time: 1. Single HIGH with DISTRIBUTIONS ONLY on all columns that lead any index plus the first columns that are different when several indexes start with the same column(s). If this statement is longer than 64K break it up into two or more statements. 2. MEDIUM on all columns not listed in the HIGH run. If this statement is longer than 64K break it up into two or more statements. 3. LOW on the entire key of every index. OR - you can just get my dostats utility which implements these protocols automatically. Dostats also provides many options and features that make managing your server stats much easier. Dostats is included in the package utils2_ak available from the IIUG Software Repository. This works best if you set DBUPSPACE or PDQPRIORITY, DS_TOTAL_MEMORY, and DS_MAX_QUERIES (see the paper noted below for details) to increase in-memory sort space above the defaults. The information above is found in the Informix Performance Guide and in a paper by John Miller III at: www-128.ibm.com/developerworks/db2/zones/informix/library/techarticle/miller/020 3miller.html Art S. Kagel ----- Original Message ----- From: Uday Prabhu At: 2/26 22:31 Hi, Our billing application is working on IDS 7.31.UD6W5. Most of the tables in the database range in size from a few thousand to a couple of hundred thousand records. There are a couple of tables with around 7 million records each. I would like to know the recommended approach to updating statistics of my database. Can I run "Update Statistics High" for the entire database (our support people are recommending this approach) ? Is there any downside of updating statistics? Regards Uday ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Relax. Yahoo! Mail virus scanning helps detect nasty viruses!

To Unsubscribe go to the IIUG Website and login to the members' area and select the forums section you can unsubscribe to any or all forums there by clearing the radio buttons. Art S. Kagel ----- Original Message ----- From: Babak Bayat.... <ids@iiug.org> At: 3/11 13:34

thank you for comments "ART KAGEL, ...." <kagel@bloomberg.net> wrote: To Unsubscribe go to the IIUG Website and login to the members' area and select the forums section you can unsubscribe to any or all forums there by clearing the radio buttons. Art S. Kagel ----- Original Message ----- From: Babak Bayat.... At: 3/11 13:34 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Yahoo! Mail Use Photomail to share photos without annoying attachments.