Data Details

Click the Data Details button to show the following information in the Data (Table) Details dialog:

Table Name
The name of the table. The tables most in need of reorganizing are listed first.
Rows
The number of rows in the table.
Row Segments
The total number of row segments for a table. A row segment is all or part of one row that is contained on one page. A row may have one or more row segments.
Segments Per Row
The average number of segments per row.
A Segments Per Row value of 1 is ideal, and any value above 1 indicates a high degree of fragmentation. For example, a value of 1.5 means that half of the rows are partitioned.
State
The state of the table. Upon opening the Data Details dialog box, the state may show as being OK (does not need defragmentation) or Fragmented (requires defragmentation).
After it is reorganized, the state shows as Defragmented.

To reorganize a fragmented table, select the table in the dialog and click the Defragment button.

Click the Close button to close the dialog.

Related topics

About fragmentation

Reorganize All button


More Information