You can reorganize a table using the following methods:
By compressing out deleted rows: Removes deleted records to make the space occupied by them available for more records.
You can also optionally choose to preserve the order in which rows were added to the table.
By selected index: Specifies that the rows of the table are rearranged by the key values of an index or keyed logical file that is built over the specified table. You can select only an existing index. Your list of indexes is determined by the schema you select.