Summary
Views are a powerful database tool that in their simplest form can be used as a low-overhead way to simplify queries or provide column-level or row-level security. They also can be leveraged to mask schema or layout changes in existing applications, and for this reason should be considered during all phases of database design.
Partitioned views can provide a unified view of a table that has been partitioned, or split, to improve performance or accommodate geographically distributed data. The indexed view, new to SQL Server 2000, may have some drawbacks, but can improve performance for certain types of queries.
The next chapter, “Creating and Managing Stored Procedures in SQL Server,” discusses one of the most powerful features of SQL ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.
