Truncate vs Delete

From: Sykle <Sykle_at_fcmail.com>
Date: Tue, 16 Feb 1999 17:40:17 -0500
Message-ID: <7acs6i$dlq$1@birch.prod.itd.earthlink.net>

I have a table that will contain messages every time a report is run. This table will be cleared out every week, deleting messages from 2 weeks ago. OK, so I am aware that 'Truncate' will clear ALL data from my table, whereas
'Delete' will not. However, I cannot use 'Truncate' for my purposes here.
However, to my knowledge, 'Delete' will not release the space for additional
'Inserts'. I want to be able to run this report every week, without
requiring our DBA to go in and release the space every other week. So, the question is, will the space released by the 'Delete' be reused (a)immediately, (b) only when the table has run out of space and goes back to the beginning, or (c) not until a DBA goes in a releases the space?

Thanks in advance,

Greg Received on Tue Feb 16 1999 - 16:40:17 CST