title: DB2 delete statement
body: <p>I need to delete the data from <code>table1</code> for the ids present in <code>table2</code>.
  I have executed the following statement but it is going for table scan even though indexes are present:</p>
  
  <pre><code>DELETE FROM table1 t1 WHERE t1.ID IN (SELECT T.ID FROM table2 T) ;
  </code></pre>
  
  <p>Is there some other way to join tables in DB2 for delete statement so that I can avoid table scan.</p>