Difference between a clustered index and unique clustered index?

Question

question

minijebu asked Sep 5, '13

Difference between a clustered index and unique clustered index?

What is the difference between a clustered index and unique clustered index?

index

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2013-09-05T09:42:46Z

Cyborg answered Sep 5, '13

If your clustered index is unique, it doesn't allows you any duplicate keys in your table and if Clusterd index is non unique it allows you duplicate keys but internally SQL Server adds 4 bytes hidden uniquifier column with the keys to make them unique.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

minijebu commented · Sep 05, 2013 at 12:30 PM

Thanks Cyborg

0 ·

question