title: SQL performance based on the WHERE clause
body: <p>I am trying to reuse a query, instead of creating several scenarios. Basically I am getting a COUNT from a big table.</p>
  
  <p>The question is: am I going to lose performance on the long run if I am using </p>
  
  <pre><code>SELECT COUNT(id) FROM [Documents] WHERE UploadDate &gt; '1900/1/1' AND UploadDate &lt; GETDATE()
  </code></pre>
  
  <p>Instead of a simple</p>
  
  <pre><code>SELECT COUNT(id) FROM [Documents]
  </code></pre>
  
  <p>Basically the 2 queries would return the same thing, because I want to return ALL the records in this case. But under some other circumstances, the date pair will use different parameters.</p>