SQL Performance Tips #2. Avoiding running on the heap and CTEs… | by Guilherme Banhudo | Jan, 2021

[ad_1]


Avoiding running on the heap and CTEs vs Temporary Tables

Guilherme Banhudo
Photo by Cris Ovalle on Unsplash
Using a CTE (top) vs a temporary table (bottom) queries
Execution plan — CTE
Execution plan — temporary table
A diagram depicting the typical indexing decision workflow on table creation. (credits toptal.com)

Read More …

[ad_2]


Write a comment