1. How is the index mainitained for a partitioned table?
2. Whether SQL Server has an overhead in maintaining INDEX in a partitioned table compared to a non-partitioned one?
3. If i insert few rows, does it affect the INDEX statistics in all partitions or only the affected partition.
I would like to find out more details on how SQL Server manages INDEX on a partitioned table.
View Complete Post