Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow delete
Message
General information
Forum:
Oracle
Category:
Other
Title:
Miscellaneous
Thread ID:
00957347
Message ID:
00957355
Views:
14
This message has been marked as a message which has helped to the initial question of the thread.
>I'm trying to delete 10 million records from a 50 million record table in chunks of about 20,000 records, then a COMMIT.
>
>The process is very slow, about 100,000 per hour. All triggers, and constraints on this table are disabled?
>
>What am I missing?

What does your DELETE SQL look like? Do you have an index on filtered columns in the WHERE clause? That many records will still take some time. Also, as you delete, indexes are being updated. You could drop indexes that are not involved in your WHERE clause. Maybe dropping all indexes will help as well.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform