MSDN: Improving Performance with SQL Server 2000 Indexed Views

By Bill Graziano on 5 October 2000 | 0 Comments | Tags: Performance Tuning, Indexes


This article describes the new indexed views capability of SQL Server 2000 Enterprise Edition. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed. Follow the link to MSDN: Improving Performance with SQL Server 2000 Indexed Views...

Discuss this article: 0 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Related Articles

Which is Faster: SAN or Directly-Attached Storage? (21 January 2008)

Using Included Columns in SQL Server 2005 (14 January 2008)

SQL Server Indexes: The Basics (26 November 2007)

Benchmarking Disk I/O Performance: Size Matters! (30 October 2007)

What I Wish Developers Knew About SQL Server (Presentation) (11 October 2007)

Introduction to Parameterization in SQL Server (7 August 2007)

Using Indexed Computed Columns to Improve Performance (16 January 2007)

SQL Server Storage Engine Team Blog (7 June 2006)

Other Recent Forum Posts

Help Writing Stored Procedure (4 Replies)

if child exists with same location, take it, else (9 Replies)

Updating columns (1 Reply)

Returning values from 2 queries to a single row (3 Replies)

PATINDEX (2 Replies)

No results (1 Reply)

migration oracle with XML to sql server (5 Replies)

DateAdd (4 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -