Design primary, secondary, composite, inverted, spatial, and approximate indexes. Balance faster reads against storage, write amplification, and maintenance cost.
