Mercurial > gemma

annotate schema/updates/1003/01.add-indexes.sql @ 4988:61eb65394a13

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Only use JSON path when configure feature layers with Geoserver REST API.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 05 Mar 2020 11:59:11 +0100
parents 3dc2694557f1
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
4006
3dc2694557f1 Speed up time based filtering of gauge measurements and predictions
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
1 CREATE INDEX gauge_measurements_measure_date
3dc2694557f1 Speed up time based filtering of gauge measurements and predictions
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
2 ON waterway.gauge_measurements (measure_date);
3dc2694557f1 Speed up time based filtering of gauge measurements and predictions
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
3
3dc2694557f1 Speed up time based filtering of gauge measurements and predictions
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
4 CREATE INDEX gauge_predictions_measure_date
3dc2694557f1 Speed up time based filtering of gauge measurements and predictions
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
5 ON waterway.gauge_predictions (measure_date)