Interview questionsStart free
Databases & data modellingEasySDE-1
The 'My orders' page runs SELECT * FROM orders WHERE user_id = ? ORDER BY created_at DESC LIMIT 20 and takes 2 seconds on a 200M row table. How do you fix it?
Asked at
AmazonFlipkartSwiggy
Think first
Answer out loud as you would in the room — clarify, give numbers, name the trade-off — then compare with the model answer.
Saved on this device. Create a free account to keep it on every device.
Practise this with Sam
A real mock interview, out loud, with an honest scorecard. Free to start.