• Article

Index Properties (Storage Page)

Use this page to view or modify filegroup or partition scheme properties for the selected index. This page is available for clustered indexes only.

Options

  • Filegroup
    Stores the index in the specified filegroup. The list only displays standard (row) filegroups. The default list selection is the PRIMARY filegroup of the database.

  • Filestream filegroup
    Specifies the filegroup for FILESTREAM data. This list displays only FILESTREAM filegroups. The default list selection is the PRIMARY FILESTREAM filegroup.

  • Partition scheme
    Stores the index in a partition scheme. Clicking Partition Scheme enables the grid below. The default list selection is the partition scheme that is used for storing the table data. When you select a different partition scheme in the list, the information in the grid is updated.

    The partition scheme option is unavailable if there are no partition schemes in the database.

  • Filestream partition scheme
    Specifies the partition scheme for FILESTREAM data. The partition scheme must be symmetric with the scheme that is specified in the Partition scheme option.

    If the table is not partitioned, the field is blank.

  • Partition Scheme Parameter
    Displays the name of the column that participates in the partition scheme.

  • Table Column
    Select the table or view to map to the partition scheme.

  • Column Data Type
    Displays data type information about the column.

    Note

    If the table column is a computed column, Column Data Type displays "computed column."

  • Allow online processing of DML statements while moving the index
    Allows users to access the underlying table or clustered index data and any associated nonclustered indexes during the index operation.

    Note

    This option is not available for XML indexes, or if the index is a disabled clustered index.

  • Set maximum degree of parallelism
    Limits the number of processors to use during parallel plan execution. The default value, 0, uses the actual number of available CPUs. Setting the value to 1 suppresses parallel plan generation; setting the value to a number greater than 1 restricts the maximum number of processors used by a single query execution. This option only becomes available if the dialog box is in the Rebuild or Recreate state.

    Note

    If a value greater than the number of available CPUs is specified, the actual number of available CPUs is used.