title: Using clustered indexes on non-primary key columns when using IN vs = operator
body: <p>If my Product table has a CategoryId column, I understand it can be a good practice to make the CategoryId the clustered index rather than the primary key ProductId.</p>
  
  <p>Does this still apply if most of my queries against the Product table with look like <code>select * from Product where CategoryId in (1, 2)</code> instead of the more typical <code>select * from Product where CategoryId = 1</code></p>