mediumAmazon Meta Snowflake

What is a correlated subquery, and why can it be a performance trap?

Correlated subqueries read naturally but can execute per row (O(n squared)), a classic slow-query cause. The signal is recognizing them and rewriting as joins or window functions.

Updated Aug 2026 · Grounded in real Applied AI Engineer interview loops and written to a senior-engineer editorial bar.

Correlated subqueries read naturally but can execute per row (O(n squared)), a classic slow-query cause. The signal is recognizing them and rewriting as joins or window functions.

Unlock the other 750 answers · ₹2,000 / $25Your progress and mastery stay saved · 6 months · one payment · no auto-renew

UP NEXT ON YOUR JOURNEY

Next in this trackHow do you compute multiple aggregation levels at once (GROUPING SETS, ROLLUP, CUBE)?Next in this trackHow do you count distinct values at scale (HyperLogLog and approximate aggregation)?Next in this trackWhat is a LATERAL join (CROSS APPLY), and when do you need it?

DISCUSSION · 0

No comments yet — be the first to share your approach.