title: SQL Server - When to use Clustered vs non-Clustered Index?
body: <p>I know primary differences between clustered and non clustered indexes and have an understanding of how they actually work. I understand how clustered and non-clustered indexes improve read performance. But one thing I am not sure is that what would be the reasons where I would choose one over the other. </p>
  
  <p>For example: If a table does not have a clustered index, should one create a non-clustered index and whats the benefit of doing</p>