Supportnet / Forum / Anwendungen(Java,C++...)
SQL Abfrage optimieren
Frage
Wie könnte man folgendes SQL Statement optimieren?
[code]SELECT DISTINCT p.PER_ID, p.PER_FIRST_NAME, p.PER_LAST_NAME,
(SELECT TRVL_ID FROM PEV_TRAVEL WHERE TRVL_CONF LIKE ´%to%´ AND TRVL_ID in (SELECT TRVL_ID FROM PEV_BOOKING_TRAVEL WHERE PER_ID = p.PER_ID)) as anreise,
(SELECT TRVL_CONF FROM PEV_TRAVEL WHERE TRVL_CONF LIKE ´%to%´ AND TRVL_ID in (SELECT TRVL_ID FROM PEV_BOOKING_TRAVEL WHERE PER_ID = p.PER_ID)) as anreise_conf,
(SELECT TRVL_ID FROM PEV_TRAVEL WHERE TRVL_CONF LIKE ´%back%´ AND TRVL_ID in (SELECT TRVL_ID FROM PEV_BOOKING_TRAVEL WHERE PER_ID = p.PER_ID)) as rückreise,
(SELECT TRVL_CONF FROM PEV_TRAVEL WHERE TRVL_CONF LIKE ´%back%´ AND TRVL_ID in (SELECT TRVL_ID FROM PEV_BOOKING_TRAVEL WHERE PER_ID = p.PER_ID)) as rückreise_conf,
p.PER_FMNO_CNO
FROM
(VW_T_PERSON p INNER JOIN PEV_BOOKING_TRAVEL pbt ON p.PER_ID = pbt.PER_ID)
ORDER BY p.PER_LAST_NAME[/code]
Antwort 1 von Newan
sag aml welche DB....da gibbet unterschiede!