RE: Fragmentation

Posted in 1998

Richard Thomas — Tue, 15 Sep 1998 14:23:01 +1000 — source: Informix-list mailing list archive (1991-1998)

ckchan5@my-dejanews.com wrote > > I am using Informix 7.24 UC5, and I did fragmentation for all my tables and > indexes, the questions are : - > > 1) How to check back all the fragmentation style ? (Round robin or expression) > 2) How to know which dbspace use for each table fragmentation > > Regards > Have a look at: sysfragments.fragtype (Index or Table) strategy (Expression or Round-robin) evalpos (Fragment evaluation position order 0 -> NumFrags-1) exprtext (Expression text) dbspace (DBspace fragment resides in) in the system catalogs. Also, see the SQL Reference chapter on the System Catalog for more info. cheers RET