title: MySQL, delete and index hint
body: <p>I have to delete about 10K rows from a table that has more than 100 million rows based on some criteria. When I execute the query, it takes about 5 minutes. I ran an explain plan (the <code>delete</code> query converted to <code>select *</code> since MySQL does not support <code>explain delete</code>) and found that MySQL uses the wrong index.</p>
  
  <p>My question is: is there any way to tell MySQL which index to use during delete? If not, what ca I do? Select to temp table then delete from temp table?</p>