PASS logo

November 14-17

In person. In Seattle

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.

Get updates

Sign up to get the latest conference information, announcements and price bump reminders direct to your inbox.

Redgate will only contact you about PASS Data Community Summit and SQL Saturday, unless you separately request emails about Redgate.