Long-Running Transactions

Talk it through with a coach who asks guiding questions and gives hints until you reach the answer. Pass to mark the challenge as completed.

The problem

  • hard
  • Pro

A reporting script opens a transaction, then runs for three hours, and during that time the database slows down and the table grows on disk. Explain why a long-running transaction causes these problems and what you'd do about it.

Talk this problem through with an AI coach

This is a Pro challenge. Sign in with Google, then upgrade to start a voice session.

Start free →