title: How does IN clause affect performance in oracle?
body: <pre><code>UPDATE table1 
         SET col1 = 'Y'
       WHERE col2 in (select col2 from table2)
  </code></pre>
  
  <p>In the above query, imagine the inner query returns 10000 rows. Does this query with IN clause affect performance?</p>
  
  <p>If so, what can be done for faster execution?</p>