You said, "The plans do not give any clue to their performance difference." But there ARE indications. The thickness of the arrows are a real indicator. The thicker the arrow, the more rows in that part of the plan. I can see that there are thicker arrows with the CTE. More rows will, generally, take more time. Hover with the mouse over the arrows to see the number of rows.