Re: Slow system after rebuilding tables

Posted in 1998

Art S. Kagel — Wed, 29 Apr 1998 13:36:30 -0400 — source: Informix-list mailing list archive (1991-1998)

Paul Finkel wrote: > > My system (instance of ONLINE) and the machine (NCR 3435) are running > very slowly. > History: > on 4/23/98 we dumped the data from two of our major tables ("case" and > "person") > modified the text files to accomodate the change to the tables > rebuilt the tables with the modified schemas and reloaded data. > Then we rebuilt indexes. [SNIP] Did you UPDATE STATISTICS? According to the release notes recommendations? Art S. Kagel