![Clustered Vs Non Clustered Index. Explaining Key SQL Performance… | by Farhad Malik | FinTechExplained | Medium Clustered Vs Non Clustered Index. Explaining Key SQL Performance… | by Farhad Malik | FinTechExplained | Medium](https://miro.medium.com/v2/resize:fit:718/1*d3_gN3wrhMOSjI6lI30TfA.png)
Clustered Vs Non Clustered Index. Explaining Key SQL Performance… | by Farhad Malik | FinTechExplained | Medium
![The primary key is the default clustered index in SQL Server and MySQL. This implies a 'clustered index penalty' on all non-clustered indexes. The primary key is the default clustered index in SQL Server and MySQL. This implies a 'clustered index penalty' on all non-clustered indexes.](https://use-the-index-luke.com/static/fig05_02_index_on_heap_table.x1.Zxzjx7lW.png)
The primary key is the default clustered index in SQL Server and MySQL. This implies a 'clustered index penalty' on all non-clustered indexes.
![sql server - What are the differences between a clustered and a non- clustered index? - Stack Overflow sql server - What are the differences between a clustered and a non- clustered index? - Stack Overflow](https://i.stack.imgur.com/kFSWR.png)