title: How to reduce 'number of executions' in MS SQL Execution Plan
body: <p>Does anyone know how to reduce the 'Number of executions' you can see in the execution plan of a SQL Query in MS SQL Server?</p>
  
  <p>We have a query that runs slow on one production server (others are fine). When checking the execution plan, we see that one of the first steps is a Clustered Index Scan. On the servers that run fine, this scan is executed once. On the one that runs slow, it is executed 4 times.</p>
  
  <p>We read here (<a href="http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p2.aspx" rel="nofollow noreferrer">http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p2.aspx</a>) that you should try to reduce it, but we can't find any tips on how to do this.</p>
  
  <p>Both servers run the same version of Windows (2003) and SQL Server (2000).</p>
  
  <p>Any help would be appreciated.</p>