This edition of the Distributed SQL Tips and Tricks blog looks how and why Yugabyte handles efficient row retrieval using a primary key, as well as the implications of not having one.
There’s a subtle, but critical, difference between the two notions business-unique key and primary key in a relational database. For example, in a “users” table, the “user_id” could be the primary key while the “email_address” (which must be not null and unique) could be the business-unique key. The columns that implement each notion may or may not coincide. This post shows that,
…