fastest way of deleting all rows in a table

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 28 Feb 2003 15:27:59 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7035D17F6@lnewton.leeds.lfs.co.uk>

Hi Richard,

you are correct (again). I even got it right when I wrote up the FAQ answer to which Jonathan alludes. The HWM is indeed set to the very start, its the number of extents that remain after the truncate which is the MINEXTENTS setting.

I shall put on a hair shirt for the rest of the afternoon.

Regards,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Richard Foote [mailto:richard.foote_at_bigpond.com] Posted At: Friday, February 28, 2003 3:17 PM Posted To: server
Conversation: fastest way of deleting all rows in a table Subject: Re: fastest way of deleting all rows in a table

Hi Norman,

Note that truncate always resets the HWM back to the very start (ie. blocks
= zip)

Cheers

Richard Received on Fri Feb 28 2003 - 09:27:59 CST