Backend · Mid-level · Theory

A query that used to run in milliseconds now takes seconds after the table grew to tens of millions of rows. How would you investigate, and what can you do about it?

~4 min by voice

How to approach it

This checks whether the candidate can systematically diagnose a slow query from its execution plan instead of guessing: find the cause (no index, index not used, stale statistics), design the index correctly and apply changes safely in production while accounting for their cost.

Have you seen this question in a real interview?

Answers0

Avg. score—

Strong—

Practiced0

Topics

indexes query performance sql

Similar questions

У нас есть таблица заказов на сотни миллионов строк и составной B-tree индекс по (user_id, created_at). Расскажите, как устроен такой индекс внутри и как база по нему выполняет запрос «последние 20 заказов пользователя». А если в запросе фильтр только по created_at — индекс поможет? Mid-level What are a primary key and a foreign key? And how would you model a many-to-many relationship, for example students and courses? Junior You join the orders table with the payments table, and the total revenue in the report suddenly grows almost threefold. How would you look for the cause, and how would you fix it? Mid-level Tell me about a time you denormalized a data model for the sake of performance. What price did you have to pay for it? Senior The orders list page has started taking several seconds to load, and in the logs you see hundreds of near-identical SQL queries per HTTP request. What's going on, and how would you fix it? Mid-level

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Best with headphones · ~4 min