title: How do I create a DESC index in MySQL?
body: <p>I have a table from which I need to obtain rows ordered by a field in descending order. When running an <code>EXPLAIN</code> query like the following:</p>
  
  <pre><code>EXPLAIN SELECT ... FROM table WHERE ... ORDER BY field DESC
  </code></pre>
  
  <p>I get <code>Using where; Using filesort</code> in the <code>Extra</code> column. So I try to create a <code>DESC</code> index:</p>
  
  <pre><code>CREATE INDEX name ON table (field DESC);
  </code></pre>
  
  <p>But when I run <code>EXPLAIN</code> again, I get the same <code>Using where; Using filesort</code> in the <code>Extra</code> column and the performance is pretty much the same.</p>
  
  <p>What am I doing wrong?</p>