AGS S1 E6 HD - Table Reorganization

If a table has an excessive number of extents, right click on it and choose Reorganize. After choosing a better next extent size, you can choose to recreate the table in-place using “alter index to cluster” or by exporting the data to a file, optionally using the Informix High Performance Loader (HPL). In all cases, everything is done for you, and all dependent objects such as views are faithfully recreated afterwards. The biggest time saving is if you choose HPL, which is extremely quick and avoids long transaction errors for large tables: HPL normally has a steep learning curve, and its complexity is hidden by AGS.

Go back to videos