Fundamentals of Table Expressions, Part 12 – Inline Table-Valued Functions
SQL Performance
OCTOBER 13, 2021
This article is the twelfth part in a series about named table expressions. I also compare them with stored procedures, mainly focusing on differences in terms of default optimization strategy, and plan caching and reuse behavior. For details, see Part 10 in the series. The plan for Query 1 is shown in Figure 1.
Let's personalize your content