Database Health Check / Findings
Illustrative
Illustrative example. Not a real customer report. No database was assessed.
- Concern
A query’s filter or sort pattern may not align with an existing index.
- Illustrative finding
A possible mismatch to validate against a real execution plan. This does not claim that an index is missing or that a slowdown occurred.
- Evidence to gather
- A representative query and its real execution plan
- Existing index definitions, query predicates and sort pattern
- Write costs of relevant indexes and workload context
- Suggested next steps
- Inspect a representative query plan.
- Compare predicates and sort pattern with existing indexes, including write costs.
- Test a candidate safely under a representative workload.
- Decide whether to deploy, then monitor the workload.
