MSSQL - How to use Table Partitioning for Big Data Tutorial

Tutorial of the Microsoft SQL Server Table Partitioning Step by Step Explained

[vaio]

thanks! why the script generation creates cluster index and in the next line creates drop line for the same index?

[kirkvukonich]

Unfortunately, this is not an apples-to-apples comparison because there are different clustered indexes on both versions, and that constitutes a significant difference. The *same* clustered index that was added to the new, partitioned version needs to be on the original before a comparison takes place. Having the same clustered index on the original will remove the key lookup on 40M records, the nested loop join, and the index scan, and the disparity will not be so exaggerated.