Composite, Partial, and Covering Indexes

A single-column index handles simple filters well, but most real queries filter on multiple columns, target a narrow subset of rows, or need columns the index does not store.

These situations call for more precise indexing strategies: composite indexes that span multiple columns, partial indexes that cover only the rows you care about, and covering indexes that let the database skip the table entirely.