title: Oracle difference between !=(<>) and not in
body: <p>Today I heard that a query with <code>&lt;&gt;</code> will take more time to execute than one with <code>not in</code>.
  I tried to test this and with an equal plan had the following time results:</p>
  
  <p><code>select * from test_table where test &lt;&gt; 'test'
  0,063 seconds
  select * from test_table where test not in ('test')
  0,073 seconds</code></p>
  
  <p><strong>So the question is, what is the difference between <code>&lt;&gt;</code> and <code>not in</code> for a single condition and what is better to use.</strong></p>