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