O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

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

Other Index Operations

Following is a quick review of other index operations you can perform using Transact SQL and/or the Enterprise Manager.

Indexes on Views and Computed Columns

SQL Server 2000 allows you to create indexes on computed columns and views. This new feature can improve the performance when performing queries against complex views or on computed columns. If a user queries a non-indexed view, SQL Server dynamically builds the resultset, which can be time-consuming. If an index is created on a view, SQL Server stores the resultset of the view in the database, improving query times because the resultset is no longer created dynamically. Modifications made to the tables in the view are also reflected in the index (even after index ...

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