Export (0) Print
Expand All

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.

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.

NoteNote

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.

NoteNote

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.

NoteNote

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft