Partitioned Views
NOTE
As of this writing (December 2000), SQL Server 2000 produces inefficient execution plans for some of the queries presented in this section. SQL Server 7.0, by contrast, produces good plans with nearly all the examples. Microsoft has been alerted to the problem and promises a fix in SQL Server 2000, Service Pack 1, which is due sometime in the spring of 2001. I demonstrate both types of plans on the assumption that the inefficient plans currently produced by SQL Server 2000 are the result of bugs that you may encounter yourself. If you run into one of these, you may want to check with Microsoft to see whether a patch or service pack has been released that addresses the issue.
Simply put, a partitioned view is a view that ...
Get Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
