25 out of 38 rated this helpful - Rate this topic

SQL Indexes

SQL Server 2000

A Microsoft® SQL Server™ 2000 index is a structure associated with a table or view that speeds retrieval of rows from the table or view. An index contains keys built from one or more columns in the table or view. These keys are stored in a structure that allows SQL Server to find the row or rows associated with the key values quickly and efficiently.

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.