How to Create index for cte
<p>I have a query:</p>

<pre><code>With Cte as (some code)

Select * 
from Cte
order by id 
</code></pre>

<p>Can I create a index for this cte?</p>

<p>I'm using ms SQL Server 2005</p>

<p>Thanks.</p>