Search code examples
sql-serverdatabase-partitioning

Can the performance in SQL Server be boosted by index partitioning without the table partitioning

I don't want to restructure the entire table, I merely want a boost on a couple of indexes. Will it work if I do not add ON MyPartitionScheme(MyPartitionColumn) to the TABLE, but will only add it to the proper index(es)?

Solution

  • The answer is, yes, it can and the performance improves, although not as drastically.

    It appears that the effect of applying the partition scheme on the table itself is essentially partitioning its primary key.