Re: Rebuild indexes

Posted in 2006

Art S. Kagel — Mon, 03 Apr 2006 18:11:02 -0400 — source: Usenet: comp.databases.informix

Hendrick wrote: > Thanks for your response. Do I do this for every index? There is three > indexes within the same table. Also how do I go about updateing > statistics on that table? > See the Performance Guide manual and John Miller III's paper about the latest optimizations inside later IDS versions and how to take advantage of them to compute statistics faster: http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/miller/0203miller.html Or just get my dostats utility in the package utils2_ak available from the IIUG Software Repository (new release dated 3/27/2006 will be posted shortly, I uploaded it last week and Peter's working on it). Art S. Kagel