title: Do I need to set up a column with just a few possible values as an index for tSQL?
body: <p>I'm creating an SQL Server 2008 database that may contain millions of records and I was wondering if I need to define the following as indexes:</p>
  
  <ol>
  <li><p>TINYINT column that may contain only 0 and 1?</p></li>
  <li><p>TINYINT column that may contain only: 0, 5, and 6?</p></li>
  </ol>
  
  <p>PS. Both of these columns will be used in the WHERE clause for selection.</p>