What is indexing strategy in large-scale systems?

Indexing strategy defines how indexes are designed for performance and scalability.

In large systems, indexing must balance read speed and write overhead. Strategies include selective indexing, composite indexes, partial indexes, and avoiding over-indexing. Indexes must align with query patterns and workload characteristics.