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 extents, list of all table extents and extent individual sizes and list of dbspaces and size in dbspaces, which the table consumes. All sizes are given in pages.

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 consumes a large size on the disk, which might be a sign that the table has a large number of deleted rows. In this case you can just compact the data by removing deleted rows in table extents without changing any of the table storage properties.
• The table has a large number of extents. It might be a result of incorrect selection of the First/Next Extent Size parameters. In this case you have to modify the values of these storage parameters before compacting the data in the table.