🚀 go-pugleaf

Svein Erling Tysv�r wrote:

> Hi Tiedo!
> 
> I cannot tell why your query takes that much longer, but in general I
> think using COUNT in a subquery can be slow and I've never even tried
> using a GROUP BY within a subquery. I think your example can be
> written a bit differently:
> 
> SELECT DISTINCT G.GerechtigdeID, G.AdminNrPensioen
>   FROM G_Gerecht G
>   JOIN T_SelectStanden T ON G.GerechtigdeID = T.GerechtigdeID
>   JOIN G_RekenBasis B ON B.GerechtigdeID = G.GerechtigdeID
> WHERE B.RekenBasisCode = 50
>   AND EXISTS(SELECT *
>     FROM G_Gerecht Gr
>     JOIN T_SelectStanden Tr ON Gr.GerechtigdeID = Tr.GerechtigdeID
>     JOIN G_RekenBasis Br ON Br.GerechtigdeID = Gr.GerechtigdeID
>     WHERE Br.RekenBasisCode = 50
>       AND B.RekenBasisID = Br.RekenBasisID
>       AND NOT EXISTS(SELECT *
>         FROM G_RekenBasis Br2
>         WHERE Br2.GerechtigdeID = Gr.GerechtigdeID
>           AND Br2.RekenBasisCode = 50
>           AND Br.RekenBasisID < Br2.RekenBasisID))
> ORDER BY G.AdminNrPensioen
> 
> I'm a bit too tired just now to check whether this is right or if it
> can be simplified, but HTH, Set

Thank you for your suggestion.
This problem is in my "thursday/friday project", so I have to wait a
few days with trying it.

Tiedo