RE: Informix database reorganization

Posted in 1998

-=Eclypse=- — Thu, 1 Oct 1998 10:40:05 -0400 (EDT) — source: Informix-list mailing list archive (1991-1998)

It does defrag moving from one dbspace to another (if there's enough contiguous space in the new dbspace). What I was wanting to know is if it defragments if you alter fragment...init in the same dbspace that the table is currently in. Jon<*> On Thu, 1 Oct 1998, Jonathan Knight wrote: > Does moving a table from one dbsapce to another also defragment the table - > reducing the number of extents used? Could you use it as a mechanism to > reduce the fragmentation of a database? > -snip-