Update Statistics....dropping distributions

Posted in 2003

Topics: Performance & Tuning, Platform-Specific Issues, Versions, Editions & End-of-Life

Sam Gentsch — Thu, 20 Mar 2003 20:34:28 — source: IIUG Forums & Mailing Lists

I was at a "training day" in Denver last year and heard a presenter (maybe John Miller or Carlton Doe, but do not quote me on that) that there are times that distributions can just be added to and added to until they are huge and hindering performance. The proposed fix was to run a ...LOW DROP DISTRIBUTIONS. Are there any rules of thumb of when and how often one should drop distributions? (IDS 9.3 & 7.30, Solaris 7 & 8) Thanks in advance, Sam Gentsch Informix Database Evangelist Voyant Technologies, Inc. (303) 223-6641

↪ replying to Sam Gentsch

Jack Parker — Thu, 20 Mar 2003 21:07:05 — source: IIUG Forums & Mailing Lists

Every time - just before you update statistics high or medium. cheers j. ----- Original Message ----- From: "Sam Gentsch" <sgent@voyanttech.com> To: <ids@iiug.org> Sent: Thursday, March 20, 2003 3:34 PM Subject: Update Statistics....dropping distributions [776] > I was at a "training day" in Denver last year and heard a presenter > (maybe John Miller or Carlton Doe, but do not quote me on that) that there are times that > distributions can just be added to and added to until they are huge and hindering performance. > The proposed fix was to run a ...LOW DROP DISTRIBUTIONS. > > Are there any rules of thumb of when and how often one should drop distributions? > > (IDS 9.3 & 7.30, Solaris 7 & 8) > > Thanks in advance, > > Sam Gentsch > Informix Database Evangelist > Voyant Technologies, Inc. > (303) 223-6641 > > > >

Glossary

UPDATE STATISTICS