title: How to decrease response time of a simple select query?
body: <p><code>MarketPlane</code> table contains more than 60 million rows.</p>
  
  <p>When I need the total number of plane from a particular date, I execute this query which takes more than 7 min. How can I reduce this time ?</p>
  
  <pre><code>SELECT COUNT(primaryKeyColumn) 
  FROM   MarketPlan 
  WHERE  LaunchDate &gt; @date
  </code></pre>
  
  <p>I have implemented all things mentioned in your links even now I have implemented <code>With(nolock)</code> which reduce response time is to 5 min.</p>