Database Index Optimization overview

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.