Access SQL performance

[DasWolf]

Verwende mal EXISTS wie folgt:

Select Top 30 * from
(SELECT ABFStatKundenNr, sum(ABFStatUmsatz) as total from ABFStat WHERE ABFStatDatum > #01/01/2023#
and EXISTS (SELECT NULL FROM sPersKto WHERE sPersKto.PersKtoNummer = ABFStat.ABFStatKundenNr AND PersKtoArt = 68 )
group by ABFStatKundenNr)
order by total desc;