title: Mysql - sequence of multiple column indexes
body: <p>Say if I have a query that look like this:</p>
  
  <pre><code>SELECT * FROM table WHERE category='5' and status='1' LIMIT 5
  </code></pre>
  
  <p>The table has 1 million rows. </p>
  
  <p>To speed things up, I create index (status, category), i.e. multiple column index.</p>
  
  <p>There are 600 categories but only 2 status (1 or 0). I'm wondering if there is any difference in performance if I create index (category, status) instead of index (status, category).</p>