Mercurial > gemma
view run-app.sh @ 3003:92818da6133d
Cleanup VIEW definition
NULLS LAST is not necessary on non-nullable columns;
avoid materializing unused columns in a CTE;
use boolean value directly instead of comparing to auto-casted string;
gauge_measurements might contain not only waterlevels;
avoid unnecessary subselects.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 10 Apr 2019 18:50:20 +0200 |
parents | 9b2218a6c6ae |
children |