Re: fragmented system tables

Posted in 1998

david.ashby@workcover.nsw.gov.au — Thu, 14 May 98 09:42:37 +1000 — source: Informix-list mailing list archive (1991-1998)

Sven, The way I get around this problem is to alter the system catalogs "next size" after the database is first created. If I am doing a dbexport I add the alter table statements before the first "create table". I find that a next size of 1 meg is sufficient for everything except the SPL tables. Regards David Ashby ______________________________ Reply Separator _________________________________ Subject: fragmented system tables Author: Sven Tolkemit <tolkemit@nanu-nana.de> at WCA-INET Date: 13/5/98 12:50 PM 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