阅读背景:

主键列的外键约束-问题?

来源:互联网 

What are the pros/cons from a performance/indexing/data management perspective of creating a one-to-one relationship between tables using the primary key on the child as foreign key, versus a pure surrogate primary key on the child? The first approach seems to reduce redundancy and nicely constrains the one-to-one implicitly, while the second approach seems to be favored by DBAs, even though it creates a second index:What are the pros/cons from a performance/index




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: