easy5 pts · first answer countstransactionsmaintenanceperformance
Deleting 5 crore old rows
You must delete 5 crore old rows from a live table. Why is deleting in chunks of, say, 10,000 per transaction usually better than one big DELETE?
Discussion 0
Join free to post in the discussion.
Related questions
- Durability in ACIDDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- What ROLLBACK undoesDatabase Administrator
- Emptying a staging tableDatabase Administrator
- Getting disk back from a MySQL tableDatabase Administrator
- What C in ACID meansDatabase Administrator
- What I in ACID meansDatabase Administrator
- Statements without BEGINDatabase Administrator