Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Slow delete
Message
Information générale
Forum:
Oracle
Catégorie:
Autre
Titre:
Divers
Thread ID:
00957347
Message ID:
00957355
Vues:
15
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform