Surrogate keys usually slow performance.

Question

Quizplus · Accepted Answer

Surrogate keys are usually auto-generated and have no inherent meaning or relationship to the data they represent. They are often used in place of natural keys, which are derived from business rules or existing data. While surrogate keys may provide some benefits such as simplifying database design and improving data integrity, using them can also lead to slower performance due to the additional processing required to generate and manage them. However, the impact on performance will depend on various factors such as the size of the database and the specific implementation of the surrogate key.

Surrogate Keys Usually Slow Performance