Re: fastest way of deleting all rows in a table

From: Noons <nsouto_at_optusnet.com.au.nospam>
Date: 28 Feb 2003 14:11:05 GMT
Message-ID: <Xns933198038EF6Tokenthis@210.49.20.254>

Following up on Richard Foote, 01 Mar 2003:

>> A close second but you will have to re-allocate the storage, re-grant any
>> privileges, re-create indexes etc. etc. so if the intention was to simply
>> repopulate with new data, that's what truncate was invested for.

>
> Invested ?????
>
> I'm going to bed ...
>

Didn't know you worked at AMP? ;)
Same here...

-- 
Cheers
Nuno Souto
nsouto_at_optusnet.com.au.nospam

Received on Fri Feb 28 2003 - 08:11:05 CST