rename mytable to mytable_001 create table mytable (... ....) insert into mytable (fieldlist) select ... from mytable_001So far so good. Then, just to check, went into properties of the new table and the renamed old table. Row count was the same; the space taken by the data was shrunk a bit, not much. But the space taken by the index went from 4,289 M to 0,008 M. Which means that there's some serious fragmentation of index blocks occurring during the regular inserts (mind you, this was the audit table, no updates ever). Tried with another table and there it was, the size of index shrank drastically.