You are given a slow-running query that joins five tables and returns a large result set. Walk through your systematic approach to diagnosing and optimizing it.

Sample answer preview

Diagnosing and optimizing a slow multi-table join query requires a systematic approach rather than guessing. As a junior DBA, following a structured process ensures you identify the actual bottleneck rather than making changes that may not help or could even make things worse.