title: How to remove this filesort?
body: <p>I have problem, my slow query is still using filesort.
  I can not get rid of this extra flag. Could you please help me?</p>
  
  <p>My query looks like this:</p>
  
  <pre><code>select `User`,
         `Friend` 
  from `friends` 
  WHERE 
       (`User`='3053741' || `Friend`='3053741') 
       AND `Status`='1' 
  ORDER by `Recent` DESC;
  </code></pre>
  
  <p>Explain says this:</p>
  
  <p><a href="http://blindr.eu/stack/1.jpg" rel="nofollow noreferrer">http://blindr.eu/stack/1.jpg</a></p>
  
  <p>My table structure and indexed (it is in slovak language, but it should be the same):</p>
  
  <p><a href="http://blindr.eu/stack/2.jpg" rel="nofollow noreferrer">http://blindr.eu/stack/2.jpg</a></p>
  
  <p>A little help is needed, how to get rid of this filesort?</p>