A UUID or a sequence for the primary key

• A

  UUIDs are slower because they are longer to compare

• B

  Auto-increment keys are unsafe precisely because they reveal how many rows exist

• C

  Random keys scatter inserts across the whole index, causing page splits that sequential keys avoid

• D

  UUIDs cannot be used as a clustered index key in most databases