![sql server - Performance of Non Clustered Indexes on Heaps vs Clustered Indexes - Database Administrators Stack Exchange sql server - Performance of Non Clustered Indexes on Heaps vs Clustered Indexes - Database Administrators Stack Exchange](https://i.stack.imgur.com/Ud6dG.png)
sql server - Performance of Non Clustered Indexes on Heaps vs Clustered Indexes - Database Administrators Stack Exchange
![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.
![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_03_secondary_index_on_clustered_index.x1.A+AMD+Lr.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.
![Clustered vs Non-Clustered Index | HEAP vs Clustered Table | SQL Index Page | Non-Clustered Index - YouTube Clustered vs Non-Clustered Index | HEAP vs Clustered Table | SQL Index Page | Non-Clustered Index - YouTube](https://i.ytimg.com/vi/KfNlBhu4L-U/maxresdefault.jpg)