Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Query takes long time Expand / Collapse
Posted Tuesday, April 2, 2013 2:38 AM



Group: General Forum Members
Last Login: Tuesday, January 26, 2016 6:59 AM
Points: 1,606, Visits: 1,595
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?

//All our dreams can come true, if we have the courage to pursue them//
Post #1437746
Posted Tuesday, April 2, 2013 2:58 AM



Group: General Forum Members
Last Login: Yesterday @ 5:18 AM
Points: 45,619, Visits: 44,147
Without more info, no idea.

Please post query, table definitions, index definitions and execution plan, as per

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1437756
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse