ECO-DAT-DATA-003 — Large unused indexes¶

Category: Data (DAT)
Family: Data (DATA)
Layer: Data
Tier: 3
Severity: note
Tags: indexes
Legacy ID: ECO-DATA-003

Summary¶

Unused indexes waste storage and slow writes.

Indexes are not free; they multiply storage and write cost.

{
  "confidence": 0.6,
  "notes": "Validate via usage stats.",
  "type": "storage"
}

{
  "languages": [
    "database"
  ],
  "method": "query"
}

{
  "guidance": "Drop truly unused indexes; reassess queries.",
  "tradeoffs": "Risk if usage stats incomplete."
}

{
  "system_layers": [
    "data"
  ]
}