Estimated Execution Plan Help

• infodemers

  SSCommitted

  Points: 1513

  More actions

  May 27, 2010 at 6:36 am

  #222060

  I ran the Estimated Execution Plan for a query.

  I get the following results for two (NODE 1 and 3)

  My query run for hours....Can anyone tell me if this results is telling me what I should look at to make it faster?

  Sort the Input

  Physical Operation........................Sort

  Logical operation................Distinct Sort

  Estimated I/O Cost.....................4842.39

  Estimated CPU Cost.....................72.6198

  Estimated Number of Executions...............1

  Estimated Operator Cost..............4915(49%)

  Estimated Subtree Cost..................9933.9

  Estimated Numbers of Rows..............2150020

  Estimated Row Size......................1248 B

  Node ID......................................1

  Thanks in advance!

• Gail Shaw

  SSC Guru

  Points: 1004494

  More actions

  May 27, 2010 at 11:09 am

  #1173465

  Please post table definitions, index definitions and execution plan, as per http://qa.sqlservercentral.com/articles/SQLServerCentral/66909/

  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

• Grant Fritchey

  SSC Guru

  Points: 397721

  More actions

  May 27, 2010 at 11:58 am

  #1173501

  Yep, sorry, completely insufficient data. Couldn't possibly even guess with what you've provided. Please follow Gail's link & post the additional information.

  ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software