Home     Documentation     Sliding window scenario

How to Partition Tables with Data

5. Specify which indexes should be aligned

Forward » « Back

This step appears if a table has indexes that will not be aligned after the partitioning is complete.

In this step, we can choose, which indexes should be aligned and which shouldn't. We analyze the queries to Production.TransactionHistory table to see if the performance can be improved by aligning indexes, and then make all the indexes aligned.

It is also important that when indexes are aligned, SQL Server can switch partitions quickly and efficiently.

Specify which indexes should be aligned