mardi 6 janvier 2015

Uniquifier vs Clustered Index

Lets say for example that I have a table structured this way:



ID1 int
ID2 int
ID3 int
DTM datetime


I'm only able to create a unique clustered index on the table if I include ID1, ID2, and ID3 (a combination of two of them or individually would lead to duplicate rows). Would it be better performance wise to create a clustered index by ID1, ID2, and ID3? Or create a clustered index on just ID1 and have SQL Server add a uniquifier to the index to make each row unique?


I know that the uniquifier is 4 bytes in size (same for ints) so technically it would save 4 bytes per row if I make the latter index, but I'm not sure how this would affect my queries.


Aucun commentaire:

Enregistrer un commentaire