Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: Friday, October 16, 2015 10:53 PM
Points: 1,605, Visits: 1,592
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: Today @ 9:27 AM
Points: 43,445, Visits: 40,580
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
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