Fundamentals of Table Expressions, Part 12 – Inline Table-Valued Functions
SQL Performance
OCTOBER 13, 2021
I also compare them with stored procedures, mainly focusing on differences in terms of default optimization strategy, and plan caching and reuse behavior. Before implementing the function itself, here’s code to create a supporting index on the Sales.Orders table: USE TSQLV5 ; GO. CREATE INDEX idx_nc_cid_odD_oidD_i_eid ON Sales.
Let's personalize your content