title: Optimize Oracle SQL with large 'IN' clause
body: <p>Here I have a query like below:</p>
  
  <pre><code>SELECT field
  FROM table
  WHERE value IN ('val1', 'val2', 'val3', ... 'valn')
  </code></pre>
  
  <p>Let's say there are 2000 values inside the IN clause, the value doesn't exist in other table. Do you have any idea to speed up this operation?</p>
  
  <p>The question is open to accept any kind of methods..</p>
  
  <p>Thanks!</p>