I have a stored proc which takes quite long time. I have seen the execution plan and I found that order by takes 44% of the total query cost. What are the actions that should be taken to improve the performance for sorting the data?
Ryan
//All our dreams can come true, if we have the courage to pursue them//