Microsoft Interview Question

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