Stairway to SQL Server Indexes: Step 1, Introduction to Indexes

Posted on SQL Server Central See other posts from SQL Server Central
Published on Wed, 16 Mar 2011 06:00:00 UT Indexed on 2011/03/18 16:16 UTC
Read the original article Hit count: 548

Filed under:

Indexes are the database objects that enable SQL Server to satisfy each data access request from a client application with the minimum amount of effort, resulting in the maximum performance of individual requests while also reducing the impact of one request upon another. Prerequisites: Familiarity with the following relational database concepts: Table, row, primary key, foreign key

SQL Backup Join SQL Backup’s 35,000+ customers
to compress and strengthen your backups

"SQL Backup will be a REAL boost to any
DBA lucky enough to use it." Jonathan Allen.
Download a free trial now.

© SQL Server Central or respective owner