PASS logo

2021 Summit video library

Query Tuning Tips Concerning Table Expressions

Itzik Ben-Gan

T-SQL supports four kinds of named table expressions: derived tables, CTEs, views and inline table valued functions. From a query tuning perspective, SQL Server treats table expressions very differently compared to persisted tables. This session provides query tuning tips concerning table expressions, and shows you how to apply those tips to address common query tuning needs.