More on UUIDs and Clustered Indexes
My SQL Server genius pointed me to this article by Kimberly Tripp about the problem with GUIDs as primary and/or clustering key. (GUIDs and UUIDs are the same thing in this context. Microsoft folks often call them GUIDs.)
Another article suggests this isn’t a big deal with Azure SQL because a network write is slower than a page split anyway.
But the advice still seems to be that UUIDs don’t make the best clustering key. You want something narrow to keep down index size.
So I’ve slept on it. Do I still like this layout for the notes table?
id - auto-incrementing integer clustering primary key
noteID - UUID, unique
userID - int
Yes, I like it.