FULL OUTER JOIN zeigt nicht alle records

[MyRealName]

Diese Abfrage hier geht, ist aber sehr langsam :

Code:

SELECT B.*, GE.*
FROM (
      SELECT G.E E_Loc, G.S S_Loc, G.Tipo Tipo_Loc, G.Batch Numero_Loc, CAST(COALESCE(SUM(G.Debit-G.Credit), 0) AS Currency) Saldo_Loc, G.ACCT
      FROM GL G
      WHERE G.Fecha BETWEEN '01/01/2016' AND '12/31/2016'
      GROUP BY G.E, G.S, G.Tipo, G.Batch, G.Acct
     ) B
FULL JOIN GL_EXT GE ON (GE.E=B.E_Loc AND GE.S=B.S_Loc AND GE.Tipo=B.Tipo_Loc AND GE.Numero=B.numero_Loc AND GE.Acct=B.Acct)