Master index optimization techniques. Learn how to choose the right columns to index, avoid over-indexing, and maintain database performance at scale.