Re: fastest way of deleting all rows in a table

On Sat, 1 Mar 2003 09:48:55 +1000, "Richard Foote" <richard.foote_at_bigpond.com> wrote:

>Hi Kenneth,
>
>Don't confuse keeping the allocated extents (for subsequently reused) to the
>resetting of the HWM.
>
>Truncate *always* resets the HWM.
>
>Cheers
>
>Richard

Hi Richard,

Ok, I'll be accurate as well :-)
What I meant was : When truncating with "drop storage", HWM will be reset and drop down to the initial extent. When truncating with "keep storage", HWM will not drop down, but still be reset within the last allocated extent. So I said "reset" while meaning "drow down".

• Kenneth Koenraadt