RE: Upgrade and Update Stats

Posted in 2009

Habichtsberg, Reinhard — Tue, 12 May 2009 14:02:34 +0200 — source: Usenet: comp.databases.informix

> Reinhard wrote: > > Obnoxio The Clown wrote: > > > > Habichtsberg, Reinhard wrote: > > > > > In the Migration Guide it is recommended to make an "update > > statistics > > > medium" on all not-leading index rows. With the databases > > we are migrating > > > it would last days if we did so. > > > > Really? > > Perhaps weeks. What do you imply? Thank's OTC, now I know what you implied: Try it and see how fast update statistics medium runs. I did so and saw that it only lasts half an hour to complete on a database with 1.3 TB. Regards, Reinhard.