title: Which SQL statement is better?
body: <p>Which Statement is better?</p>
  
  <pre><code>Update tableA set field1 = @AAA
  where fieldB = 12345
  and fieldC = 'Ask'
  and fieldA &lt;&gt; @AAA 
  </code></pre>
  
  <p>Or  </p>
  
  <pre><code>Update tableA set field1 = @AAA
  where fieldB = 12345
  and fieldC = 'Ask'
  </code></pre>
  
  <p>Assume only less than 5 rows match the criteria, is it redundant to add fieldA &lt;> @AAA?  It may slow down search, however it filter out those records don't need to be updated. So I don't know if I should always add this condition.</p>