ECO-DAT-DATA-007 — No partitioning for large tables¶

Category: Data (DAT)
Family: Data (DATA)
Layer: Data
Tier: 3
Severity: warning
Tags: partitioning
Legacy ID: ECO-DATA-007

Summary¶

Large tables without partitioning lead to expensive queries and maintenance.

Partitioning reduces scan scope and improves manageability.

{
  "confidence": 0.65,
  "notes": "Strong when datasets grow.",
  "type": "io"
}

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

{
  "guidance": "Partition by time/key; enforce pruning; archive older partitions.",
  "tradeoffs": "Migration complexity."
}

{
  "system_layers": [
    "data"
  ]
}