Re: Freeing space after delete

In Article <3f3gb9$91v@emory.mathcs.emory.edu> Ian Timms writes: >There has been some discussion on this with relation to Online, >but what of SE, what happens by way of space recovery if anything >when rows are deleted from a table under SE? > The rows are marked for re-use, and will be used for any new rows before the table grows in size again. The only way to reclaim the space is to do an alter index to cluster, or to drop and re-create the table, having dumped it's remaining contents somewhere first. Regards Neil