![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 - Clustered index update, how changing the index only at different column value? - Database Administrators Stack Exchange sql server - Clustered index update, how changing the index only at different column value? - Database Administrators Stack Exchange](https://i.stack.imgur.com/QtGH5.jpg)
sql server - Clustered index update, how changing the index only at different column value? - Database Administrators Stack Exchange
Columnstore Index: Differences between Clustered/Nonclustered Columnstore Index - Microsoft Community Hub
![sql server - Clustered index update, how changing the index only at different column value? - Database Administrators Stack Exchange sql server - Clustered index update, how changing the index only at different column value? - Database Administrators Stack Exchange](https://i.stack.imgur.com/4csNt.jpg)
sql server - Clustered index update, how changing the index only at different column value? - Database Administrators Stack Exchange
![SQL SERVER - Identify Table Where Clustered Index is Not a Primary Key - DMV - SQL Authority with Pinal Dave SQL SERVER - Identify Table Where Clustered Index is Not a Primary Key - DMV - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2016/04/clpk3.png)