title: Indexing for multiple columns
body: <p>I have to run a query on a table  where there are more than 10 million rows.
  The table structure is </p>
  
  <pre><code>user(varchar 100),
  played(int 11),
  won(int 11),
  lost(int 11),
  drawn(int 11),
  user1(varchar 30),
  user2(varchar 30).
  
  
  Where
  User - primary key
  user1 - index
  user2 - index
  </code></pre>
  
  <p>MySql database engine is MyISAM.</p>
  
  <p>My problem is -
  When I run the below query it is taking more than 17 seconds.  </p>
  
  <pre><code>SELECT * FROM h2hstats
  WHERE (won+lost+drawn) &gt; 5
    AND (user1 = '717054941' OR user2 = '717054941')
  </code></pre>
  
  <p>How can I reduce this execution time?</p>
  
  <p>Will I make another indexing on (won+lost+drawn) columns?</p>