Reduce the ''Number of Executes'' seen in Execution plan

• roshen jose

  SSC Veteran

  Points: 201

  More actions

  January 12, 2006 at 7:02 pm

  #110698

  Hello,

  I have a select query which (Inner) Joins 4 tables. This query takes a very long time to execute.

  When I saw the Execution plan for this query, one of the tasks (Product.PK_product) is a 'Clustered Index Seek' and the tool tip shows that the 'Number of Executes' for this step is 28536.

  I read that the number of Executes should be 1 in the ideal conditions. Can some one please suggest some thing to reduce the number of executes?

  Thanks in advance.....

   

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  January 12, 2006 at 8:56 pm

  #614529

  Roshen please post your code so we can review it and help ID where to help make changes.

   

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net