Re: Delete with Huge table

From: Nicolas Bronke <newsgroup_at_trinity.de>
Date: Thu, 25 Nov 1999 15:39:10 +0100
Message-ID: <383d3d3e_1@news2.prserv.net>

> I want to know if Oracle works fine for deleting part of huge table (about
> 50 000 000 rows).
> My system is AIX 4.2
> Oracle v7.3.4
> No archive log.
>
> My performance on my system for deleting 1 000 000 rows is very bad.
> How can I improve that ?
>
> (I already have dropped all my indexes)
>

If you do not need a rollback, use truncate table <tablename> then all records will be deleted without using rollback possibilities.

regards
--
Regards
Nicolas Bronke Received on Thu Nov 25 1999 - 08:39:10 CST