How would you optimize a complex SQL query on a large dataset?
Anoniem
I discussed indexing, query optimization techniques, and using EXPLAIN to analyze execution plans. I also suggested table partitioning and materialized views to improve performance