Audit and optimize search indexes for performance and coverage

Search performance improves when indexes are audited and optimized against actual query patterns rather than guessed based on schema.

• · index_schema
• · query_logs
• · coverage_metrics

• · index_audit_report
• · optimization_recommendations

• · Elasticsearch
• · Algolia
• · database indexes

Index exists; query logs available; performance baseline known

• · Missing indexes on high-cardinality filters
• · Over-indexing (storage bloat)
• · Query planner not using intended index

• · Query log analysis
• · Index fragmentation detection
• · Query planner inspection