title: A table structure
body: <p>I have a table called table1.  It has 3 columns:</p>
  
  <pre><code>id, int, auto incrementing, primary key
  id2,int
  description,varchar(255)
  </code></pre>
  
  <p>The only key that is set is id as primary key.</p>
  
  <p>From this I run this query:</p>
  
  <pre><code>SELECT * FROM table1 WHERE id2=1 OR 5 OR 2 LIMIT 250;
  </code></pre>
  
  <p>I have not set any other keys other than id as <code>primary key</code> and there are about 20 possibilities for id2 values (all integers) and three are selected randomly for each query.</p>
  
  <p>The table is currently MYISAM.  </p>
  
  <p>What can I do to make the query above faster? </p>
  
  <p>What other keys should I set on table1?</p>
  
  <p>Would combining id and id2 together in a key make it faster?</p>