Shrink table space

Occasional Contributor

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!

 

namerowsreserveddataindex_sizeunused
BATCHHISTORY1633411300676744 KB299166952 KB172048 KB1337744 KB
0 Replies