title: Does a normal Delete command remove indexes for those records?
body: <p>Quick question I had a table with 1.7 million records and performed a delete which left me with 400k records which is fine.</p>
  
  <p>I have several indexes on this table, I am just wondering does a normal</p>
  
  <pre><code>delete * from my_table where value = 1
  </code></pre>
  
  <p>also make the index size smaller by removing the indexes which are no longer needed because of the records deleted ?</p>