Index Properties (Storage Page)

  • Article

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.

Options

  • 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.

    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.

See Also

Other Resources

Creating Indexes (Database Engine)
INDEXPROPERTY (Transact-SQL)
Index with Included Columns

Help and Information

Getting SQL Server 2005 Assistance