All geek questions in one place

If a Sequential Guid Primary Key Column Is a Clustered Index?

The purpose of using a sequential pointer is that you can use cluster indexes without the high levels of fragmentation that usually exist in a cluster index, if it was a regular guid, right?

+3
source share
2 answers

Yes you are right.

+1
source

First of all, to clarify, the primary key and the clustered index are 2 separate and different things, that is, one is not related to the other (PCs can be non-clustered, cluster indexes can be non-PC).

, , : " GUID ". , , , , . , , , .

, GUID ( ), GUID, , GUID, , , GUID ( , , SQL- , , - ).

+7

Source: https://habr.com/ru/post/1723244/

More articles:


All Articles