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.
Indexes, like tables, use pages. The structure ...