Michael L John (2/27/2015)
They are PK indexes, so they are clustered.
A primary key does not have to be a clustered index.
A clustered index does not have to be the primary key.
When you create a primary key using the GUI in SQL Server, it automatically makes it clustered (I think?).
This may or may not be the best use of the clustered index, your mileage may vary.
Ah. Ok, good to know. 🙂
I did create the PK using the table designer in SSMS, so it did create clustered indexes (according to the Indexes list in SSMS). I can't imagine a situation where you'd want a PK that's not a clustered index, though (at least, I can't imagine one right now :doze: ) 😉