A query that joins three tables and was fast in staging is timing out in production under real traffic. Walk through how you'd diagnose it.

The illustrated walkthrough is behind sign-in.

Every prompt in the library is public. Any free InterviewOS account unlocks the diagram, the model answer, and the self-check.