Vista Global interview question

How will you optimized SQL Query?