Re: Slow system after rebuilding tables

Posted in 1998

Mark Collins — Wed, 29 Apr 1998 10:07:34 -0600 — source: Informix-list mailing list archive (1991-1998)

> 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. You didn't mention, so I have to ask - did you update statistics after all of this? Can you isolate the sql statements that are running slowly? If so, try running them through isql with SET EXPLAIN ON and see what shows up. Mark Collins mcollins@us.dhl.com No matter how much Jell-O you put in a swimming pool you still can't walk on water.