ShipMonk interview question

Optimization of database , indexing