title: Can i request SQL Server to cache a certain result set?
body: <p>There is a certain query that is being called from an ASP .NET page. I studied the execution plan of that query in Management Studio and 87% is for a sort. I badly need the sorting or else the data displayed would be meaningless. </p>
  
  <p>Is there anyway that I can request SQL Server to cache a sorted results set so it will return the data faster in consequent runs? </p>
  
  <p>Or is SQL Server smart enough to do the cache handling and am I doing mistake by trying to force it to cache results, if that is possible? </p>
  
  <p>Any relevant information will be highly appreciated and thanks a lot in advance :)</p>
  
  <p><strong>UPDATE:</strong><br>
  I just read in an article that creating a View with a clustered index will increase performance because the index will persist the data in a view to disk. Is this true? How do i get about doing this? Any articles?</p>