In SQL Server 2008, just as you can divide tables into partitions. Partitioned indexes are indexes in which the index pages are separated horizontally into multiple physical locations based on range of values in the index column. The physical locations for partitions are filegroups. Partition indexes are use for the same reason that for partition […]
HighTechnology