Re: Delete operation is very slow

From: Nicolas Bronke <NBronke_at_t-online.de>
Date: 28 Oct 1998 16:19:20 GMT
Message-ID: <717g68$u5a$1@news00.btx.dtag.de>

Regarding to the truncate command:

no roll back is available -> that is the reason why it is so fast
truncate deletes ALL records. You cannot limited it.

Regards
Nicolas Bronke

krines_at_my-dejanews.com schrieb in Nachricht <7118s6$eua$1_at_nnrp1.dejanews.com>...
>Hi,
>
>we have oracle version 7.3 and have a problem with the delete operation.
Every
>time we delete all records from the database, the time for this operation
>increases. The delete operation is very simple:
>
>delete * from label
>commit
>
>First we thought that the rollback segments are the problem but now we have
no
>more ideas.
Received on Wed Oct 28 1998 - 10:19:20 CST