displayName
Database Index Optimization
workflowKind
operational
triggerType
scheduled
typicalCadence
monthly
complexity
single-team
description
Optimizes database index configurations to improve query performance and
reduce storage overhead -- analyzing slow-query logs and execution plans
to identify missing index opportunities, evaluating existing indexes for
usage frequency and identifying unused or redundant indexes for removal,
assessing index-bloat levels and scheduling reindex operations, modeling
composite-index column ordering against query selectivity statistics,
testing index changes against production-representative workloads in
staging, validating lock-free index creation strategies for
zero-downtime deployment, and benchmarking query-latency improvements
post-optimization. Produces index optimization report and migration
scripts. Excludes schema redesign.