&gt; For example, CTE is only evaluated once, even if it&#x27;s referenced in multiple places, and those places may have conflicting ideas of what&#x27;s the best way to evaluate it.<p>Not disputing what you&#x27;re saying, but I swear I read something the other day recommending being careful using CTE&#x27;s as they are re-executed once for every reference in the query (or something to that effect).