title: SQL - IN vs. NOT IN
body: <p>Suppose I have a table with column which takes values from 1 to 10. I need to select columns with all values except for 9 and 10. Will there be a difference (performance-wise) when I use this query:</p>
  
  <pre><code>SELECT * FROM tbl WHERE col NOT IN (9, 10)
  </code></pre>
  
  <p>and this one?</p>
  
  <pre><code>SELECT * FROM tbl WHERE col IN (1, 2, 3, 4, 5, 6, 7, 8)
  </code></pre>