TL;DR * In a relational database, primary keys are essential. Don't roll without them. * Primary key is by default promoted to the clustered index for the table. * Table rows are physically stored in clustered index order on disk. * An ever-increasing integer key