title: Default index in MS SQL Server
body: <p>When I use the below query to create index for a column in MS SQL Server</p>
  
  <pre><code>create index IX_indexname on tablename(columnname);
  </code></pre>
  
  <p>without mentioning it as clustered or non clustered index, what index will be created? Which is the default index? </p>