Re: Upgrade and Update Stats

Posted in 2009

Obnoxio The Clown — Tue, 12 May 2009 12:48:11 +0100 — source: Usenet: comp.databases.informix

Habichtsberg, 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? Well, in my experience, UPDATE STATS MEDIUM takes a couple of seconds per table, let's be generous and say 30. Do you really have over 200,000 tables? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.