indexes

Why Your SQL Query Is Slow: Indexes and Optimization Basics

How an index actually works, why adding one sometimes changes nothing, and the handful of query rewrites that turn a slow report into a fast one.