Re: TABLE UNWANTED FRAGMENTATION

BEATRIZ ROCHA wrote: > > I did an oncheck -pe and I get the following on the temporary db space. Is > this normal. Why is the temporary db space fragmented if there are no > tables in it? Is this affecting performance? [SNIP] But there are tables in it, temp tables. > I have one more question. I am re-creating a table so it does not get too > fragmented over time. The only problem that I have is that the informix > tables containing the statistics are in the same dbspace. Should I drop > the sys tables for the statistics, re-create the table and update > statistics again? [SNIP] NO!!!! Do not mess with system catalog tables! It MAY be safe to perform an ALTER FRAGMENT ON TABLE sysdistrib INIT IN ... keeping it in the same dbspace but compressing it since ALTER FRAGMENT does not change the tabid of the table. I'd test that on a database you do not care about first though. The normal rule is "Leave catalog tables well enough alone!" so do not consider this a recommendation just a wild idea. Art S. Kagel