Single-Column vs Composite Indexes in SQL

What They Are, When to Use Them, and a Myth We Need to Bust