-- ══════════════════════════════════════════════════════════════
-- MIGRASI INDEKS PERFORMA
-- Jalankan sekali di database:  mysql -u <user> -p <nama_db> < migration_index_performa.sql
-- Mempercepat query terbesar aplikasi (maintenance_record & detail_part_rekap)
-- ══════════════════════════════════════════════════════════════

-- ORDER BY Waktu_Pelaporan_BD DESC dipakai setiap load Monitoring Unit
CREATE INDEX IF NOT EXISTS idx_mr_waktu   ON maintenance_record (Waktu_Pelaporan_BD);

-- Filter Open/Selesai (BD Progress vs History)
CREATE INDEX IF NOT EXISTS idx_mr_status  ON maintenance_record (Status_Penggunaan);

-- Filter unit per divisi CCR & pencarian per unit
CREATE INDEX IF NOT EXISTS idx_mr_er      ON maintenance_record (Equipment_Register);

-- Dipakai endpoint /detail-part/{nomor} dan /detail-part/pct-batch
CREATE INDEX IF NOT EXISTS idx_dpr_rekap  ON detail_part_rekap (rekap_id);

-- Dipakai progress pelaporan per tiket
CREATE INDEX IF NOT EXISTS idx_pp_rekap   ON progress_perbaikan (rekap_id);