Ed's Notes

SQL

Jan 16, 20261 min read

Choice of Keys

Advantages of Surrogate Integer Keys over Composite Keys:

  • Simpler and more efficient for database to index and join
  • Composite key changes → surrogate keys are constant (don’t have to worry about updates)

Graph View

Backlinks

  • No backlinks found