单个表上的集群、索引和分区
我在谷歌上搜索了一段时间，但找不到答案！
一个数据库表可以附加多个分区、索引和簇吗？
如果分区与索引位于同一行，会报错吗？
这有什么好处吗？
非常感谢，
祖鲁语
I've looked for a while over Google but can't find the answer!
Can a database table have multiple partitions, indexes and clusters attached to it?
Will it bring up an error if a partition is on the same row as an index?
Is there any benefit in this?
Many thanks,
Zulu
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
一个表可以有多个索引，这些索引与它是标准表、分区表还是聚集表无关。 （尽管如果表是分区的，则可以选择是在每个分区上创建单独的索引还是为整个表创建全局索引。）
一个表不能属于多个簇，因为簇决定了表的实际物理存储位置。桌子。
一个表可以有多个分区（当然，否则还有什么意义呢？）。它不能有多个分区方案，如果这就是你的意思。
我推测但尚未证实集群和分区是互斥的，因为它们可能会对表数据在磁盘上的组织方式产生潜在的冲突影响。
A table can have many indexes, and those are unrelated to whether it is a standard table, a partitioned table, or a clustered table. (Although if the table is partitioned, you have a choice about whether to create a separate index on each partition or a global index for the whole table.)
A table cannot belong to multiple clusters, since a cluster determines the actual physical storage location of the table.
A table can have multiple partitions (of course, else what would be the point?). It can't have multiple partitioning schemes, if that's what you mean.
I presume but have not confirmed that clusters and partitions are mutually exclusive, since they would have potentially conflicting effects on how the table data should be organized on disk.