MSDN Blogs

Posts

| |

|

Tips, Tricks, and Advice from the SQL Server Query Processing Team

Index Build strategy in SQL Server - Part 4-2: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)

Posted over 6 years ago

by SQL Server Query Processor Team
- 1 Comments
Source Partitioned While the table is partitioned, we may want to change the way it is partitioned when building the new index. For example, by using the same partition function and scheme, the new index can be partitioned on different columns than the...
Tips, Tricks, and Advice from the SQL Server Query Processing Team

Index Build strategy in SQL Server - Part 4-1: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)

Posted over 6 years ago

by SQL Server Query Processor Team
- 2 Comments
Recall that in the previous posts on index build, we defined "aligned" as the case when base object and in-build index use the same partition schema, and "non-aligned" to be the case when heap and index use different partition schemes, or the case when...