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 only available for Microsoft SQL Server 2000 indexes.

Filegroup

Stores the index in the specified filegroup. The list only displays ROW filegroups. The default list selection is the PRIMARY filegroup of the database.

Partition scheme

Stores the index in a partition scheme. Clicking Partition Scheme enables the grid below. The default list selection is the partition scheme used for storing the table data. Selecting a different partition scheme in the list refreshes the displayed information in the grid.

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

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.

ms177181.note(en-US,SQL.90).gifNote:
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.

ms177181.note(en-US,SQL.90).gifNote:
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.

ms177181.note(en-US,SQL.90).gifNote:
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