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

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, 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.