PASS logo

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.

Get the latest

Sign up to stay up to date with news, special announcements and educational content.

Redgate will only contact you about PASS Data Community Summit unless you separately request emails about Redgate.