SQL Server 2005 introduced the OVER
clause to enable partitioning of rowsets before applying a window function. This post looks at how this feature may require a query plan containing a ‘common subexpression spool’. This query plan construction is required whenever an aggregate window function or the NTILE
ranking window function is used.
About This Blog
Including my content from SQLBlog.com and some from SQLPerformance.com
Showing posts with label Internals. Show all posts
Showing posts with label Internals. Show all posts
Wednesday 28 July 2010
Partitioning and the Common Subexpression Spool
Subscribe to:
Posts (Atom)