Hi Friends,
We got a table which has 1.6M records, but with 300G size. It used to be a big table, we delete a huge trunk of records, but the table size was not reduced, when we check property, it only got about 1.7G free space. How can we free up the space?
Many thanks!
name | rows | reserved | data | index_size | unused |
BATCHHISTORY | 1633411 | 300676744 KB | 299166952 KB | 172048 KB | 1337744 KB |