4. Managing Tables and Views : Table Management : Techniques for Moving a Table to a New Location : Reorganize a Table
 
Share this page                  
Reorganize a Table
You can increase or decrease the number of locations currently used by a table for its data files.
To do this, use the SQL statement MODIFY...TO REORGANIZE. In VDBA, use the Modify Table Structure dialog. Use the Locations button, which is available when the Change Locations radio button is enabled, which opens the Change Locations dialog. For specific information on using this dialog, see online help.
This operation requires more overhead than simply relocating a table because it performs a table reorganization in addition to moving files. Using this operation, you can:
Expand a table that is currently using a single location to use multiple locations, including the option of no longer using the original location.
Shrink a table that is currently using multiple locations to use a single location, including the option of no longer using any of its original locations.
Reorganize a table that is currently using multiple locations to extend over a different number of locations, including the option of no longer using one or more of the original locations.
Afterwards, the table is reorganized to spread equally, in sized blocks, over the specified locations.