Re: TRUNCATE ???

Andreas Hess (ahess_at_truworths.co.za) wrote:
: Ok, this could be just me being silly, but I came across the following (in
: summary):

 [omitted]
: So it seems that a TRUNCATE of a table reverts the STORAGE parameters that
: have been changed just before the TRUNCATE...

Not exactly! It just reverts the "NEXT" part of the storage clause. The idea is that, after you truncate a table, it should grow the same way it originally did. So when you truncate a table, it sets the value for NEXT to be whatever it was when the table was created.

I believe you will find that other storage values (e.g. PCTINCREASE) will be unchanged.

-- 
-bn
random_at_interaccess.com	(PGP 2.6.2 public key available on request)
"There is no .signature -- only ZUUL!"