title: TSQL - Faster to use IN (list) or use NOT IN (list) for a small list?
body: <p>One of my columns can only contain 4 possible values (<code>val1</code>, <code>val2</code>, <code>val3</code>, <code>val4</code>).</p>
  
  <p>I need to add an additional filter in the <code>WHERE</code> clause to exlude one of those 4 values (i.e. <code>val4</code>). </p>
  
  <p>Is it going to be faster to use <code>NOT IN ('val4')</code> or <code>IN ('val1','val2','val3')</code>?</p>