Prudential Interview Question

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