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

From a pageviews table partitioned by date, your query that filters on user_id and date range is doing a full table scan. What are the most likely causes and how would you fix it?

Type your answer

0of ~130 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.

From a pageviews table partitioned by date, your query that filters on user_id and date range is doing a full table scan. What are the most likely causes and how would you fix it?

Practice more