Re: Freeing space after delete

In article Dsx@cix.compulink.co.uk, onlinedbc@cix.compulink.co.uk ("Malcolm Weallans") writes: >With SE the actions are similar to OnLine. i.e. if you delete records >froman SE table the corresponding areas are merely flagged as deleted >andcan be re-used. Hence the file size will not get smaller. With SE, to >make the file smaller do a table rebuild of any sort. The easiest way to do this is with the alter index to cluster statment. Karl