Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 206:01ac348ac4a4
Optimized Query horizontalprofile_instantaneouspoint_cruise because it is not warranted
that the name of an cruise is set. issue60
gnv-artifacts/trunk@262 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 23 Oct 2009 07:37:39 +0000 |
| parents | 6e7952fd1744 |
| children | d5cef9f17525 |
comparison
equal
deleted
inserted
replaced
| 205:6e7952fd1744 | 206:01ac348ac4a4 |
|---|---|
| 377 I.FEATUREID = M.FEATUREID AND \ | 377 I.FEATUREID = M.FEATUREID AND \ |
| 378 M.SOURCEID = ? \ | 378 M.SOURCEID = ? \ |
| 379 ORDER BY V.NAME | 379 ORDER BY V.NAME |
| 380 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \ | 380 horizontalprofile_instantaneouspoint_cruise = SELECT DISTINCT \ |
| 381 C.CRUISEID KEY , \ | 381 C.CRUISEID KEY , \ |
| 382 C.NAME VALUE \ | 382 V.NAME || ' ' || \ |
| 383 C.NAME || ' ' || \ | |
| 384 TO_CHAR(C.STARTDATE,'DD.MM.YYYY') || ' - ' || \ | |
| 385 TO_CHAR(C.ENDDATE,'DD.MM.YYYY') VALUE , \ | |
| 386 V.NAME , \ | |
| 387 C.NAME \ | |
| 383 FROM MEDIAN.CRUISE C, \ | 388 FROM MEDIAN.CRUISE C, \ |
| 389 MEDIAN.VEHICLE V, \ | |
| 384 MEDIAN.TRACK T, \ | 390 MEDIAN.TRACK T, \ |
| 385 MEDIAN.SURVEYINFO S, \ | 391 MEDIAN.SURVEYINFO S, \ |
| 386 MEDIAN.INSTANTANEOUSPOINT I, \ | 392 MEDIAN.INSTANTANEOUSPOINT I, \ |
| 387 MEDIAN.MEASUREMENT M \ | 393 MEDIAN.MEASUREMENT M \ |
| 388 WHERE C.CRUISEID = T.CRUISEID AND \ | 394 WHERE C.VEHICLEID = V.VEHICLEID AND \ |
| 395 C.CRUISEID = T.CRUISEID AND \ | |
| 389 T.TRACKID = S.TRACKID AND \ | 396 T.TRACKID = S.TRACKID AND \ |
| 390 S.SURVEYID = I.SURVEYID AND \ | 397 S.SURVEYID = I.SURVEYID AND \ |
| 391 I.FEATUREID = M.FEATUREID AND \ | 398 I.FEATUREID = M.FEATUREID AND \ |
| 392 C.VEHICLEID = ? AND \ | 399 C.VEHICLEID = ? AND \ |
| 393 M.SOURCEID = ? \ | 400 M.SOURCEID = ? \ |
| 394 ORDER BY C.NAME | 401 ORDER BY V.NAME, C.NAME |
| 395 horizontalprofile_instantaneouspoint_track= SELECT \ | 402 horizontalprofile_instantaneouspoint_track= SELECT \ |
| 396 T.TRACKID KEY , \ | 403 T.TRACKID KEY , \ |
| 397 to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \ | 404 to_char(T.STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(T.ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| T.NAME VALUE \ |
| 398 FROM MEDIAN.TRACK T \ | 405 FROM MEDIAN.TRACK T \ |
| 399 WHERE T.CRUISEID = ? \ | 406 WHERE T.CRUISEID = ? \ |