O'Reilly logo

Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required