Re: Fragmented Table

Posted in 1997

David Williams — Wed, 29 Jan 1997 00:11:22 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <32ebb39f.333488616@news.gte.com>, cburton@gte.net writes >I have recently taken over a project with over 300 stored procedures. >Because of this, sysprocbody and sysprocplan are tremendoulsy >interleaved/fragmented. Is there a way to correct this? I wasn't >sure about running index clustering or dropping and re-creating system >tables. >TIA > >Chris Burton >cburton@gte.net Do not try to drop/recreate them - they are internal tables and are not meant to modified in any way. -- David Williams