Interview questionsStart free
Storage, search & mediaEasySDE-1
Your product search uses SELECT * FROM products WHERE name ILIKE '%red shoe%' on 10 million rows and takes 4 seconds. Why is it slow and what would you build instead?
Asked at
AmazonFlipkartMeesho
Think first
Answer out loud as you would in the room — clarify, give numbers, name the trade-off — then compare with the model answer.
Go deeper
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.