truncate (was: Re: Flameless Advice Please...)
From: Robert Sullivan <bsullivn_at_home.com>
Date: Mon, 03 Jan 2000 20:32:48 GMT
Message-ID: <3871081B.1C817AB8_at_home.com>
Date: Mon, 03 Jan 2000 20:32:48 GMT
Message-ID: <3871081B.1C817AB8_at_home.com>
RC wrote:
> Also Oracle allows you to do things like TRUNCATE a table which removes all
> rows from table much faster than say deletes which can take a long time.
This brings up a question I've been wondering about for some time: why *is* 'truncate' so much faster than 'delete from'? I'm assuming it uses a different delete algoritm on the b-tree, but does anyone know for sure?
Thanks,
bob :)
Received on Mon Jan 03 2000 - 21:32:48 CET