title: What column to index on and making table search fast
body: <p>I have a table that holds stats for a game, this table will have hundreds of thousands of lines in but i need to it be searchable for the stats pages of the game.</p>
  
  <p>I am not sure what I need to do regarding indexing and how to keep the table searchable in a realistic time. I normally index the Id field which is a primary key. I don't really understand indexing so am not sure if I am doing the correct thing.</p>
  
  <p>Can anyone lend some advice please? I am using a MySQL database.</p>
  
  <p>Thanks.</p>