Re: [Q]What is going on?

From: Stanley Fung <sfung_at_mdsi.bc.ca>
Date: Thu, 04 Jun 1998 14:08:37 -0700
Message-ID: <35770CD5.6137@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 Thu Jun 04 1998 - 16:08:37 CDT