To gain some wasted space and improve performance at full table scans we can reset the table's HighWaterMark. We have 4 options to reorganize fragmented tables:
1. alter table move & rebuild table's indexes.
2. export / truncate / import
3. create table as select ( CTAS)
I will demonstrate all with the advantages and disadvantages and when to use each method.