Delete whole table in one go versus batches

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 20 Aug 2002 09:35:44 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70287E31D@lnewton.leeds.lfs.co.uk>

Ender,

Richard's advice is, as ever, excellent. However, in his haste to return the the CD player to listen top yet another David Bowie CD, he neglected to add one final stage to the procedures. I attach it here for completeness :

if your DBA refuses to truncate table for you, simply say "ah well, I better go 'DELETE FROM ,table>' but if I'm not sure, I might do a rollback when It finishes" - and that will take almost as long. :o) How to wind up a DBA in one easy lesson.

Enjoy :o)

Regards,
Norman.

PS. Morning/evening/middle of the night Richard.

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: Ender Wiggin [mailto:ender_wiggin29plus1_at_yahoo.com] Posted At: Tuesday, August 20, 2002 5:45 AM Posted To: server
Conversation: Delete whole table in one go versus batches Subject: Re: Delete whole table in one go versus batches

I love your scenario :) Will give it a try with my donut-loving DBA :) Received on Tue Aug 20 2002 - 03:35:44 CDT