title: oracle delete query taking too much time
body: <p>I have a query like</p>
  
  <pre><code>DELETE from tablename where colname = value;
  </code></pre>
  
  <p>which takes awfully long time to execute.
  What could be the reason? I have an index on colname. </p>