大型ERP等数据库系统常见的几种设计,自增长 primary key,避免用复合主键 (compound primary key),双主键,避免一次取数据库大量数据,取大量数据一定要用分页。
基于32个网页-相关网页
We keep only a compound primary key and a secondary index for each row, and answer all queries from a single index.
我们只保留了一个组合主键和一个辅助索引来完成所有的查询。
If you define a compound key, the order of columns in the primary key matches the order of columns as shown in the table in your diagram.
如果定义复合键,则主键中列的顺序与关系图的表中显示的列顺序匹配。
应用推荐