Re: Fragmented system tables

Posted in 1997

Virginia & Wayne — Sat, 26 Apr 1997 23:50:35 -0700 — source: Informix-list mailing list archive (1991-1998)

JohnSchore@aol.com wrote: > > How is one supposed to rebuild a fragmented "system" table (i.e. syscolumns). > I have been unable to add a clustered index even as user "informix". I can't > drop and reload it either (I'm not sure I'd want to anyway.) > > Thank You. John, How did you determine that your syscolumns tbl was fragmented? What type of performance impact did you observe on what type of system? Wayne Strong