Flipkart Interview Question

How can you optimise SQl queries?