Technically yes, but if a string makes sense to be the primary key then you should probably use it. This all depends on the size of the table you're making it for and the length of the string that is going to be the primary key (longer strings == harder to compare). I wouldn't necessarily use a string for a table that has millions of rows, but the amount of performance slowdown you'll get by using a string on smaller tables will be minuscule to the headaches that you can have by having an integer that doesn't mean anything in relation to the data.

使用什么作为主键并不重要，只要它是UNIQUE即可。如果您关心速度或良好的数据库设计，请使用int型，除非您计划复制数据，否则请使用GUID。

如果这是一个访问数据库或一些小应用程序，那么谁真的在乎。我认为，我们大多数开发人员之所以把旧的int或guid放在前面，是因为我们有一种方式来发展项目，并且您希望给自己留下发展的选择。

Strings are slower in joins and in real life they are very rarely really unique (even when they are supposed to be). The only advantage is that they can reduce the number of joins if you are joining to the primary table only to get the name. However, strings are also often subject to change thus creating the problem of having to fix all related records when the company name changes or the person gets married. This can be a huge performance hit and if all tables that should be related somehow are not related (this happens more often than you think), then you might have data mismatches as well. An integer that will never change through the life of the record is a far safer choice from a data integrity standpoint as well as from a performance standpoint. Natural keys are usually not so good for maintenance of the data.

我还想指出，两者的最佳方法通常是使用自递增键(或者在某些特殊情况下，使用GUID)作为PK，然后在自然键上放置唯一索引。您可以获得更快的连接，不会得到重复的记录，也不必因为公司名称更改而更新一百万个子记录。

是的，但除非您希望有数百万行，否则不使用基于字符串的键(因为它较慢)通常是“过早优化”。毕竟，字符串存储为大数字，而数字键通常存储为较小的数字。

不过，要注意的一件事是，如果您在任意键上聚集了索引，并且在索引中进行了大量的非顺序插入。写入的每一行都将导致索引重新写入。如果您正在进行批量插入，这确实会降低过程的速度。

有可能是一个非常大的误解有关字符串在数据库中。几乎每个人都认为数字的数据库表示比字符串更紧凑。他们认为db-s中的数字表示为内存中的数字。但事实并非如此。在大多数情况下，数字表示法更接近于字符串表示法。

使用数字或字符串的速度更依赖于索引，而不是类型本身。

Technically yes, but if a string makes sense to be the primary key then you should probably use it. This all depends on the size of the table you're making it for and the length of the string that is going to be the primary key (longer strings == harder to compare). I wouldn't necessarily use a string for a table that has millions of rows, but the amount of performance slowdown you'll get by using a string on smaller tables will be minuscule to the headaches that you can have by having an integer that doesn't mean anything in relation to the data.