Creating and Tuning Indexes

An index is a collection of pages associated with a table (or view) used to speed retrieval of rows from the table or enforce uniqueness.
For example, without an index, you would have to go through an entire textbook one page at a time to find information about a topic.
Microsoft® SQL Server™ 2005 uses indexes to point to the location of a row on a data page instead of having to look through all the data pages of a table.
An index contains keys built from one or more columns in the table. These keys are stored in a way that enables SQL Server 2005 to find the rows associated with the key values quickly and efficiently.

Từ khóa: Creating and Tuning Indexes, data storage , cơ sở dữ liệu, hệ quản trị cơ sỡ dữ liệu, xử lý dữ liệu, quản trị dữ liệu