AW: CTE with JOIN of two tables is much faster than a regular query

> -----Ursprüngliche Nachricht-----
> Von: Ravi Krishna <sravikrishna@aol.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
queriesout-of-the box; a CTEs require additional effort and are more difficult to maintain.  

Regards
Klaus