title: Does mySQL use index on delete?
body: <p>I have a simple query :</p>
  
  <pre><code>delete from myTable where myDateTime &lt; '2018-11-30 08:58:25.435140'
  </code></pre>
  
  <p>An <code>explain</code> shows me that it does not use myDateTime's index.</p>
  
  <p>(it does when I change it for a <code>select</code>).</p>
  
  <p>Do you have any clue?</p>
  
  <p>It's a InnoDb table.</p>