QuestionQ38

VerifiedDatabase Management and Maintenance

Which option is the best approach for migrating a large data load from one table to another, considering both total duration and blocking?

Explanation

Breaking a large migration into many transactions limits how long locks are held, reducing blocking and making the operation more manageable. Running batches in parallel can increase contention, while one large transaction can hold locks for an extended period.

Community Discussion

No comments yet. Be the first to start the discussion!