Re: [Q]What is going on?

From: Al <al_at_work>
Date: Fri, 5 Jun 1998 14:42:22 -0400
Message-ID: <6l9e5j$t388@piper.ncr.pwgsc.gc.ca>

This is inaccurate. Dropping the table would imply that the associated grants are removed.

Truncating the table will remove all of the data, and it will also release all secondary (i.e. NEXT) extents.

Stanley Fung wrote in message <35770CD5.6137_at_mdsi.bc.ca>...
>In fact, TRUNCATE drops the table and re-create it!
>
>Allan Webster wrote:
>>
>> Truncate does not use rollback (& can therefore not be recovered from),
>> so is much quicker.
>>
>> There is nothing to be gained by deleting before truncating, (except
>> perhaps a longer tea -break), & if you are going to drop the table
>> anyway, why bother doing either?
>>
>> Rgds
>> Allan
>
>--
>------------------------------------------------------------
>Stanley Fung | Software Analyst
>Mobile Data Solutions Inc. | Direct Line: (604)207-6290
>Suite 135 | Tel: (604)270-9939
>10551 Shellbridge Way, | Fax: (604)270-1310
>Richmond, B.C. | E-Mail: sfung_at_mdsi.bc.ca
>Canada V6X-2W9 | http://www.mdsi-advantex.com
>------------------------------------------------------------
Received on Fri Jun 05 1998 - 13:42:22 CDT