Interview questionsStart free
Databases & data modellingMediumSDE-2
Your ops dashboard runs: WHERE status = 'PENDING' AND created_at < now() - interval '15 minutes'. There are 300M orders but only a few thousand pending. What index would you create?
Asked at
FlipkartSwiggyZomato
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.