Creating and Managing Indexes

Indexes provide quick access to data without searching through an entire database. With SQL Server 2005, you can create indexes on tables, views, and columns. By creating indexes on tables, you can search through the data in a table quickly. By creating indexes on views, you can generate a result set of the view that is stored and indexed in the database. By creating indexes on computed columns, you can evaluate expressions and index the results (if certain criteria are met).

Indexes are separate from tables, and you can configure them automatically using the Database Tuning Advisor. This section examines the techniques you will use to work with indexes.

Understanding Indexes

Indexes, like tables, use pages. The structure ...

Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.