Re: Index clustering and performance

Posted in 1996

Topics: Performance & Tuning, Server Administration, Clustering, Grid & MACH11

Mark D. Stock — Wed, 09 Oct 1996 14:00:02 -0700 — source: Informix-list mailing list archive (1991-1998)

Land, Todd wrote: > > My database performance is declining, and my DBA wants to dump and reload > the database, hoping that will help. > > Isn't there something I can do to my indices (re-cluster?) to regain > performance? The first three rules of tuning are: 1) UPDATE STATISTICS. 2) UPDATE STATISTICS. 3) UPDATE STATISTICS. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+

Glossary

UPDATE STATISTICS