Capgemini interview question

How do you optimize SQL Queries.