> -----Ursprüngliche Nachricht-----
> Von: Ravi Krishna <sravikrishna(at)aol(dot)com>
> Gesendet: Samstag, 18. August 2018 18:25
>
> > What can I do to improve the performance of the regular query without
> using a CTE?
>
> Why do you care ? When I find that I can write a SQL 3 different ways, I will
> go for the most efficient one. So why not accept the CTE version of this SQL.
> Just curious.
We're using object mapping / entity frameworks (e.g. XPO, Entity Framework Core). These frameworks support regular queries out-of-the box; a CTEs require additional effort and are more difficult to maintain.
Regards
Klaus