Some databases don't give you a choice, and your table data is actually stored in a clustered index sorted by primary key. This means random inserts when using

Some databases don't give you a choice, and your table data is actually stored in a clustered index sorted by primary key. This means random inserts when using a UUID (without embedded time), and more page splitting.