Re: Maintaining Databases.

Posted in 2000

Obnoxio The Clown — Wed, 29 Mar 2000 08:45:51 BST — source: Informix-list mailing list archive (1991-1998)

From: jimspiers999@my-deja.com > >I am looking for someone to give me some information (how unusual for a >newsgroup). The database I am using - 200 tables, 2.1 million rows - >has not had any maintenance run on it since it was brought online 18 >months ago. Whilst it is not causing a problem I would appreciate any >info relating to anything I can do to check integrity (DBCHECK??) and oncheck -cDI >hopefully speed up if possible (it seems to be getting slower!). dbaccess dbname q n UPDATE STATISTICS<ESC> r Or get my update statistics shell script from http://www.iiug.org ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com