Comments on: Informix Table and Index Reorganization https://virtual-dba.com/blog/informix-table-and-index-reorganization/ Remote Database Administration Thu, 23 Mar 2023 21:18:37 +0000 hourly 1 https://wordpress.org/?v=6.9.4 By: Barrie Shaw https://virtual-dba.com/blog/informix-table-and-index-reorganization/#comment-23 Wed, 15 Mar 2017 02:22:39 +0000 https://virtual-dba.com/?p=28775#comment-23 In reply to Kernoal Stephens.

Defragment is different. Repack and shrink can be used to reclaim free space after rows are deleted from a table. Repack consolidates the free space by moving the rows to the beginning of the table or fragment, then shrink releases any resulting unused pages at the end of the table. The number of extents is reduced only if sufficient data has been removed. On the other hand, defragment is used to reduce the number of extents regardless of whether the amount of data has been reduced. In my next blog post, I will explain “repack shrink” in more detail as well as how they differ from defragment.

]]> By: Kernoal Stephens https://virtual-dba.com/blog/informix-table-and-index-reorganization/#comment-19 Wed, 08 Mar 2017 21:38:36 +0000 https://virtual-dba.com/?p=28775#comment-19 Version 11.50 has almost the same feature.
EXECUTE FUNCTION task(‘fragment repack shrink’, ”);

Did they just alias this to defragment or does it do something different?

]]>