CREATE INDEX idx_device_events_mac_created ON device_events (mac_address, created_on DESC);