Correlated Subqueries vs Derived Tables

One option for improving query performance is to rewrite the query in order to obtain a completely different execution plan. In this episode we look at how it's possible to rewrite queries with correlated subqueries into derived table syntax and examine what causes the difference in performance.

Subscribe and turn on notifications to never miss a weekly video: https://www.seevid.ir/c/DataWithBer...

Related blog post with example code:
https://bertwagner.com/2019/04/23/cor...

Follow me on Twitter:
Twitter: bertwagner

• #science_technology
• #sql_server
• #sql
• #correlated_subquery
• #correlated_subqueries
• #derived_table
• #execution_plan
• #performance_tuning