Mercurial > gemma
view schema/updates/1003/01.add-indexes.sql @ 4006:3dc2694557f1
Speed up time based filtering of gauge measurements and predictions
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 18 Jul 2019 19:57:10 +0200 |
parents | |
children |
line wrap: on
line source
CREATE INDEX gauge_measurements_measure_date ON waterway.gauge_measurements (measure_date); CREATE INDEX gauge_predictions_measure_date ON waterway.gauge_predictions (measure_date)