Home |  Writing |  Consulting |  Schedule |  Scripts |  Links |  About

Paul's Blog...
Top Posts
Why use Stored Procs?
10 lessons from 35K tps
SQL Server:Fresh Vision
SQL Myths
Data Architecture
CodeGen AutoAudit Trail

CS TechCast
TechEd ArCast
PASSCamp 2008 Panel
SQL DownUnder

Locations of visitors to this page

Covering Indexes ScreenCast

The goal of indexing and optimization is to reduce the number of physical page reads from the hard drives. One of the most expensive physical page read operations is a bookmark lookup. Covering indexes is one way to solve that problem.