Prudential interview question

Q) How to optimize database queries in a production server?