GlobalData interview question

Explain the query optimization techniques