title: Delete from empty table taking forver
body: <p>I have an empty table that previously had a large amount of rows.</p>
  
  <p>The table has about 10 columns and indexes on many of them, as well as indexes on multiple columns.</p>
  
  <pre><code>DELETE FROM item WHERE 1=1
  </code></pre>
  
  <p>This takes approximately 40 seconds to complete</p>
  
  <pre><code>SELECT * FROM item
  </code></pre>
  
  <p>this takes 4 seconds.</p>
  
  <p>The execution plan of SELECT * FROM ITEM shows the following;</p>
  
  <pre><code>SQL&gt; select * from midas_item;
  
  no rows selected
  
  Elapsed: 00:00:04.29
  
  Execution Plan
  ----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=19 Card=123 Bytes=73
        80)
  
  1    0   TABLE ACCESS (FULL) OF 'MIDAS_ITEM' (Cost=19 Card=123 Byte
        s=7380)
  
  
  
  
  
  Statistics
  ----------------------------------------------------------
        0  recursive calls
        0  db block gets
     5263  consistent gets
     5252  physical reads
        0  redo size
     1030  bytes sent via SQL*Net to client
      372  bytes received via SQL*Net from client
        1  SQL*Net roundtrips to/from client
        0  sorts (memory)
        0  sorts (disk)
        0  rows processed
  </code></pre>
  
  <p>any idea why these would be taking so long and how to fix it would be greatly appreciated!!</p>