Partitioning & Arsip Data

Tabel besar dipecah agar query tetap cepat.

  ALTER TABLE logs
    PARTITION BY RANGE (YEAR(created_at)) (
      PARTITION p2025 VALUES LESS THAN (2026),
      PARTITION p2026 VALUES LESS THAN (2027)
    );

Alternatif: pindahkan data lama ke tabel arsip / cold storage secara berkala.