Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

The following additional information is available for SQL Server 2005 and later objects:

  • Partitions. Indicates the number of partitions defined for the selected index.
  • Index Partitioned. Indicates whether or not the index is partitioned.
  • Partition Schema. Indicates under which file groups to map the partition.
  • Partition Function. Displays the name of the function that defines how the index should be partitioned.
  • Index Aligned. Indicates whether or not the index is aligned with its table.
  • Number of Non-key Columns. Displays the number of non-key columns used within an index.
  • Index Non-Key Columns. Displays the non-key column names.

...

The Partition entity displays information on how an index or table is partitioned. All tables and indexes in a database are considered to be partitioned , in SQL Server 2005, even if they are made up of only one partition. The data of partitioned tables and indexes is divided into units that can be spread across more than one file group in a database. The data is partitioned horizontally, so that groups of rows are mapped into individual partitions.

...