Why does this query take so long to execute?
Here's what I see in the XML for your actual plan:

&lt;WaitStats&gt;
&lt;Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="66883" WaitCount="1649" /&gt;
&lt;Wait WaitType="RESOURCE_GOVERNOR_IDLE" WaitTimeMs="56086" WaitCount="3980" /&gt;
&lt;/WaitStats&gt;
&lt;QueryTimeStats CpuTime="6665" ElapsedTime="73522" /&gt;


You can also see this information in the root node of the plan in SSMS if you don't like looking at XML:



You can read about the SOS_SCHEDULER_YIELD wait here. A good layman's explanation is that your query was only able to execute on a CPU for 6639 ms. It spent 66883 ms on a queue waiting to get on a CPU. Based on your description of the problem ("executing the view only takes 6 seconds"), you have a server performance issue instead of a query performance issue. Of course, there may be ways to make the query use even less CPU, but I would approach this problem by verifying that the server has the correct number of CPU cores/DTUs/whatever and by looking at the queries that use the most CPU on the server. Your query could run almost 12X faster if there was less load on the server.