Re: DELETE ROWS - how to recover disk space

Firstly, don't put spam filters in your post if you want a direct reply. From: Valerie <vgerauxNOvgSPAM@caramail.com.invalid> > >When I perform this : >DELETE FROM <table> WHERE <condition>; > >Rows are deleted, but I cannot recover the disk space. I >know that free rows are used later by new records, but >today my disk is more than 95% full and processing time is >excessive. > >Please help me to recover disk space. >Any idea will be greatly appreciated. ALTER INDEX TO CLUSTER; or unload and drop the table and recreate and reload it. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com