KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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. 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? 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? Any relevant information will be highly appreciated and thanks a lot in advance :) UPDATE: 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?
Tags (comma-separated)
Save Edits
Cancel