Coach note

Interviewers ask this kind of question to surface how you think, not what you remember. The strongest answers are specific, calmly told, and end on what changed.

SQL · Query planning

Explain what EXPLAIN or EXPLAIN ANALYZE does in SQL and when you would use it to troubleshoot a slow query.

Type your answer

0of ~125 wordsAbout a minute spoken

Voice isn’t supported in this browser — type your answer in the box.

Create a free account to get more critiques.

Your answer

Your answer appears here as you speak.

Explain what EXPLAIN or EXPLAIN ANALYZE does in SQL and when you would use it to troubleshoot a slow query.

Practice more