mysql 主键唯一_MySQL。关键表中的主键。唯一ID还是多个唯一键？

最新推荐文章于 2024-09-11 23:08:07 发布

RJhjjs

最新推荐文章于 2024-09-11 23:08:07 发布

阅读量317

点赞数

文章标签： mysql 主键唯一

本文链接：https://blog.csdn.net/weixin_35182419/article/details/113151889

版权

Primary key in relational tables. Composite primary key or unique primary key in those pure relational tables?

Which design would you recommend to use in MySQL for high performance? See diagram

Technical advantages and disadvantages!

Thanks everyone!

解决方案

It really depends on the type of query you're doing...

If you add an extra surrogate, you'll end up doing two unique checks instead of a single one for every insert, update and delete. That makes the composite key sound right.

But if you're constantly referencing that primary key in other foreign keys, the composite option means you end up storing twice as much information and need to do more work when joining. That makes the single key sound right.