Viewing Current Table Data Allocation

The first page of the Table Reorganization Wizard displays the current table data allocation. It includes total table size, number of rows, number of extends, list of all table extents and extent individual sizes and list of dbspaces and size in dbspaces, which the table uses.

All sizes are given in pages, which depend on the server platform. (2Kb or 4Kb)

If you see that the table requires reorganization you can start it by pressing the Next button.

For example the following scenarios might require table reorganization:

• The number of rows in the table is low but the table has a large size on the disk, which might be a result of a large number of deleted rows in the table. In this case you have to just compact the data by removing deleted rows in table extents without changing any of the table storage properties.
• The table has large number of extents. It might be a result of incorrect selection of the first/next extent sizes. In this case you have to modify the values of these storage parameters before compacting the data in the table.