nicht angemeldet
Hallo ihr drei!
Mein Abfrage sieht nun wie folgt aus:
SELECT ADRESSEN.IDNR, ADRESSEN.NAME1 /* , [...] */
FROM ADRESSEN
WHERE ADRESSEN.IDNR in (
SELECT ADR_ID
FROM ADRESSGRU
WHERE GR_ID in (2, 3 /* [...] */)
)
ORDER BY NAME1 ASC
Diese Abfrage ist doch tatsächlich ca. 1/3 schneller. Dafür schon mal ein dickes Dankeschön.
Ilja hat vorgeschlagen Aliase zu verwenden. Was bringt mir das in meinem Fall?
MfG H☼psel
--
"It's amazing I won. I was running against peace, prosperity, and incumbency."
George W. Bush speaking to Swedish Prime Minister unaware a live television camera was still rolling, June 14, 2001
Selfcode: ie:% fl:( br:> va:) ls:& fo:) rl:? n4:& ss:| de:] js:| ch:? sh:( mo:) zu:)
"It's amazing I won. I was running against peace, prosperity, and incumbency."
George W. Bush speaking to Swedish Prime Minister unaware a live television camera was still rolling, June 14, 2001
Selfcode: ie:% fl:( br:> va:) ls:& fo:) rl:? n4:& ss:| de:] js:| ch:? sh:( mo:) zu:)