Pergunta de entrevista da empresa Microsoft

Can you explain how to optimize a SQL query for large datasets?