Microsoft interview question

"How would you optimize a database query for large datasets?