Forum Discussion
ganriver
Dec 05, 2022Copper Contributor
Shrink table space
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 |
No RepliesBe the first to reply