示例:创建已分区表和已分区索引。
Example: Create a partitioned table and a partitioned index.
Q:如何计算已分区表(或者任何相关的表)的表大小和索引大小?
Q: How do I calculate the table and index size for a partitioned table (or any table for that matter)?
已分区表上的任何与现有本地索引相匹配的、附加在该表上的索引都可用。
Any indexes on the table being attached that match the existing local indexes on the partitioned table can be utilized.
Q:我如何能辨别已分区表上的索引是否被分区?
Q: How can I tell if an index on a partitioned table is partitioned?
加速数据滚入的最佳实践是,确保在滚入之前,附加表已具有与已分区表上所有本地索引精确匹配的索引。
The best practice to speed up data roll-in is to ensure that, prior to roll-in, the table being attached has indexes that exactly match all local indexes on the partitioned table.
如果已分区表包含任何xml列路径索引以外的其他全局索引,重组一个分区会导致整个表脱机。
Reorganizing a partition will put the entire table offline if the partitioned table has any global indexes besides XML column path indexes.
如果已分区表包含任何xml列路径索引以外的其他全局索引,重组一个分区会导致整个表脱机。
Reorganizing a partition will put the entire table offline if the partitioned table has any global indexes besides XML column path indexes.
应用推荐