Bits of .NET

Indexes are not magic.

Bad case

• Low-selectivity columns

• Over-indexing

Diagnosis

SET STATISTICS IO ON;

Why
Wrong index = more lookups than scans.