sql-serversql-server-2008guidclustered-indexnewsequentialid

Should a Sequential Guid primary key column be a clustered index?


The goal of using a sequential guid is so you can use clustered indexes without the high levels of fragmentation that would normally exist in a clustered index if it was a regular guid, correct?


Solution

  • Yes, you are correct.