Re: fragmented system tables

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? > > Thanks for answer! > > Sven Yes, there is. You have to unload and drop the tables. After, you can create it with "first size" and "next size" (to prevent your tables from high fragmentation) and load the tables. Note: At creating a table, the default lock level is "page". If there is enough space on the disk you can unload and load a complete database with "dbexport"/"dbimport". Maybe, it works with tapes, too (I know, it "works" with tapes, but depending on the size of db, it is verry slow). 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