Helpshift interview question

How to optimize a SQL Query on a given scenario?

Interview Answer

Anonymous

Nov 6, 2024

Minimizing the use of multiple joins, use of required columns only to reduce cardinality. Using key clustering or column partitioning.