Mercurial > gemma

comparison schema/updates/1003/01.add-indexes.sql @ 4006:3dc2694557f1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
4005:5c7e797347a3 4006:3dc2694557f1
1 CREATE INDEX gauge_measurements_measure_date
2 ON waterway.gauge_measurements (measure_date);
3
4 CREATE INDEX gauge_predictions_measure_date
5 ON waterway.gauge_predictions (measure_date)