Re: fragmented system tables

Posted in 1998

Volker Fraenkle — Wed, 13 May 1998 13:07:08 +0200 — source: Informix-list mailing list archive (1991-1998)

Volker Fraenkle schrieb: > > Sven Tolkemit schrieb: > > > > Hi people, > > > > we discovered, that the system tables (systables,sysindexes, etc.) on > > our Online 7.23.UC1 are very fragmented. We think, this leads into > > performance problems. Is there a way to defragment the tables? Sorry, I lost my glasses. You asked for the system tables. The only way I know, is to export/import the database. Yours Volker -- Volker Fraenkle E-Mail: VFraenkle@cs-controlling.de CS Controlling Phone: +49 7144 8144-0 Software Systeme GmbH Fax: +49 7144 8144-10 Riedbachstrasse 5 74385 Pleidelsheim