title: How to choose the clustered index in SQL Server?
body: <p>Usually the clustered index is created in SQL Server Management Studio by setting the primary key, however my recent question about PK &lt;-> clustered index (<a href="https://stackoverflow.com/questions/2262998/meaning-of-primary-key-to-microsoft-sql-server-2008">Meaning of Primary Key to Microsoft SQL Server 2008</a>) has shown that it is not necessary to set PK and clustered index to be equal.</p>
  
  <p>So how should we choose clustered indexes then? Let's have the following example:</p>
  
  <pre><code>create table Customers (ID int, ...)
  create table Orders (ID int, CustomerID int)
  </code></pre>
  
  <p>We would usually create the PK/CI on both ID columns but I thought about creating it for Orders in CustomerID. Is that the best choice?</p>