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