graphicek/server/database/migrations/1775671533180_sensor_values...

4 lines
270 B
SQL

CREATE INDEX IF NOT EXISTS idx_sensor_values_timestamp ON sensor_values (timestamp);
CREATE INDEX IF NOT EXISTS idx_sensor_values_sensor ON sensor_values (sensor_id);
CREATE INDEX IF NOT EXISTS idx_sensor_values_sensor_timestamp ON sensor_values (sensor_id, timestamp);