Compressor/backend/add_pks_device_code_time_index.sql

-- Run once during a maintenance window before enabling device_code-based PKS scans.
-- The oil-pressure alarm queries one compressor within a 24-hour time range.
CREATE INDEX idx_pks_device_code_sample_time
    ON pks_long_sample (device_code, sample_time);