title: deleting a big table based on condition
body: <p>i have a huge table which has no indexing on it. and indexing cant be added. i need to delete rows like this : </p>
  
  <pre><code>delete from table1 where id in (
  select id from table2 inner join table3 on table2.col1 = table3.col1);
  </code></pre>
  
  <p>but since it has huge number of rows its taking too much time. what i can do to make it faster other than indexing (not permitted).</p>
  
  <p>I am using oracle db.</p>