title: SQL performance tuning for Oracle Many OR vs IN ()
body: <p>I dont have "explain plan" on hand. Could you help to tell which of the below is more efficient?</p>
  
  <p>Option 1:</p>
  
  <pre><code>select ... 
      from VIEW_ABC 
      where STRING_COL = 'AA' 
         OR STRING_COL = 'BB' 
         OR STRING_COL = 'BB' 
         OR ...
         OR STRING_COL = 'ZZ'
  </code></pre>
  
  <p>Option 2:</p>
  
  <pre><code>select ... 
      from VIEW_ABC 
      where STRING_COL IN ('AA','BB',...,'ZZ')
  </code></pre>