Interview questions
Databases & data modellingHardSDE-2

A payments table has 14 indexes and insert latency has grown from 2 ms to 25 ms. How do you decide which indexes to keep?

Asked at
PhonePeRazorpayStripe

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.

Start free