Flipkart interview question

How can you optimise SQl queries?