indexing strategy.
Indexing strategy is deciding which indexes a database should carry: which columns, in what order, covering which queries, and what write cost that is worth. It is a portfolio decision rather than a per-query one.
Where indexing strategy fits on a long engagement.
Column order in a composite index is the detail that decides whether it is used at all. An index on (a, b) serves queries filtering on a, or on a and b, but not one filtering only on b. Teams frequently create several overlapping indexes because the existing one was not being used, without establishing why.
Indexes are not free and their cost is invisible in read benchmarks. Every insert and update maintains every index on the table, and storage grows accordingly. The useful discipline is periodically finding indexes that are never used and removing them, which almost no team does.
What an assigned team does with indexing strategy.
Query patterns change as a product does, and an index set designed two years ago is serving a different workload than the one currently running. Unused indexes accumulate while the queries that matter now go unserved.
Reviewing that against actual usage statistics is periodic work rather than a one-off design, held within an agreed committed monthly capacity.
What we use indexing strategy for.
- Composite indexes in a usable order Column order chosen from the real predicates, so the index is actually selected.
- Unused indexes removed Usage statistics reviewed, so write cost is not paid for nothing.
- Covering indexes where they pay Queries served entirely from the index, avoiding the table lookup.
How indexing strategy capacity is assigned.
Index strategy is assigned inside data capacity, reviewed against usage statistics periodically rather than designed once at launch.
Tell us what your roadmap needs indexing strategy for.
A service delivery manager replies with the disciplines we would assign, the monthly capacity and what the first month looks like.
Loading the contact form… You can also email hello@azendo.co.
We reply within one working day. No obligation, and no newsletter.