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: Tuesday, July 29, 2014 9:21 AM
Points: 1,602, Visits: 1,572
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 @ 1:14 PM
Points: 40,615, Visits: 37,081
Without more info, no idea.

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

Gail Shaw
Microsoft Certified Master: SQL Server 2008, 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