Interview questionsStart free
Databases & data modellingMediumSDE-2
Users search orders by product name, and the query uses LIKE '%shoe%' on Postgres. It is slow and getting slower. What do you do?
Asked at
FlipkartMyntraNykaa
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.