Database Management White Papers
Improving Performance With SQL Server 2005 Indexed Views
Overview This document describes the improved indexed views capability of SQL Server 2005 Enterprise Edition. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed. With SQL Server 2000, the functionality of SQL Server views was expanded to provide system performance benefits. It is possible to create a unique clustered index on a view, as well as nonclustered indexes, to improve data access performance on the most complex queries. In SQL Server 2000 and 2005, a view that has a unique clustered index is referred to as an indexed view. The discussion in this paper applies to SQL Server 2005.
| Publisher | Microsoft | File Format | HTML |
|---|---|---|---|
| Date Published | February 2005 | Downloads | 1151 |
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful? 1 out of 4 users found this white paper useful
White Paper RSS
Download
Register
