Re: Mass delete (about 100.000 records) ??

Andreas Eggen wrote:
>
> Hi,
>
> i have the question how to delete about 100.000 records in an oracle table.
>
> we do this with an sql statement that select the records to delete and then
> perform the action.
>
> The Problem is, deleting of all records takes about 2 Hours ??
>
> Anyone here in the group who has a solution for this problem ??
>
> thanks in advance
>
> Andi

You should probably supply more information pertaining to:

• the indexes on the file that may be updated by the delete.
• the query that is being used for the delete.
• the size of the table relative to the 100,000 records.

Yours,

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Fri Feb 04 2000 - 19:12:34 CST