Sql Server、复合主键和聚集索引
Sql Server 如何处理在复合主键上具有聚集索引的表的填充因子?
我假设将根据构成聚集索引的字段生成关键节点值。这是否意味着插入的每个新行都会有效地插入到索引的末尾?
How does Sql Server handle fill factor on tables with clustered indexes on composite primary keys?
I would assume a key node value would be generated based on the fields that make up the clustered index. Would this mean that each new row inserted would effectively get inserted to at the end of the index?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
不,它将按照构成索引的列的顺序插入到它所属的位置。换句话说,如果您 PK 是邮政编码和州(愚蠢的示例)并且您插入 22222, NJ,那么它将插入到 22222, NI 之后和 22222,NK 之前
No, it would be inserted where it belongs in the order of the columns that make up the index. In other words if you PK is zipcode and state (silly example) and you insert 22222, NJ then it will be inserted after 22222, NI and before 22222,NK