Re: Delete whole table in one go versus batches

Hi Norman,

You're right of course. It's the DBA that owes Ender a favour.

Yet another lovely winter's evening in sunny Canberra (or it was when the sun was up)

Cheers

Richard

Norman Dunbar wrote:
>
> 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 - 04:18:36 CDT