![Building Better Software: What About Indexing SQL Server Tables That do Not Have a Primary Key or Cluster Key Building Better Software: What About Indexing SQL Server Tables That do Not Have a Primary Key or Cluster Key](https://3.bp.blogspot.com/-KUZQYdNWcAY/V5Vkt_CslXI/AAAAAAAAAVk/KnwFBZTCWcoX6si8ROei4jsFs4-Pe5TRACK4B/s280/TableStructure.png)
Building Better Software: What About Indexing SQL Server Tables That do Not Have a Primary Key or Cluster Key
![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.Q21aCRSZ.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 - 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)
SQL SERVER - Identify Table Where Clustered Index is Not a Primary Key - DMV - SQL Authority with Pinal Dave
![Dinesh's Blog :::: Being Compiled ::::: SQL Server - Dropping Primary Key will drop the Clustered Index? Dinesh's Blog :::: Being Compiled ::::: SQL Server - Dropping Primary Key will drop the Clustered Index?](https://2.bp.blogspot.com/-9HBeDiIVWGw/WbPtoHwiNxI/AAAAAAAAFaU/aJ9ffbHpXoQNDj-kgavgkcZNaV9SYxwHQCLcBGAs/s1600/Primary%2Bkey%2Band%2Bclustered%2Bindex%2B01.png)
Dinesh's Blog :::: Being Compiled ::::: SQL Server - Dropping Primary Key will drop the Clustered Index?
![sql - Should primary key clustered index columns added to the non clustered indexes? - Stack Overflow sql - Should primary key clustered index columns added to the non clustered indexes? - Stack Overflow](https://i.stack.imgur.com/GOWo8.png)
sql - Should primary key clustered index columns added to the non clustered indexes? - Stack Overflow
![One Step To Understand Relationship Of Primary Key And Non-Clustered Indexes. – C-Sharp & SqlServer Key Concepts One Step To Understand Relationship Of Primary Key And Non-Clustered Indexes. – C-Sharp & SqlServer Key Concepts](https://rakeshmahur.files.wordpress.com/2014/12/4.jpg)