title: clustered index on "join" column or on "where" column
body: <p>I have two tables in SQL Server.<br>
  Table A has two columns: ID and Name. They are both unique.<br>
  Table B is joined to table A on the Name column.  </p>
  
  <p>Assuming most of the queries to these tables will be: </p>
  
  <pre><code>Select A.Name, B.xyz From A Inner Join B on A.Name = B.Name Where ID = 1  
  </code></pre>
  
  <p>Which column in table A do I want to create a clustered index on? ID to speed up the WHERE or Name to speed up the JOIN?</p>