Indexes Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Indexes Editor lets you manage columns and basic properties of an index and view index statistics.

To edit an index

  1. Open an editor on the index. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you manage columns that make up the index. On opening, this tab shows the existing columns. For each column, the datatype (and if applicable the precision in brackets) and whether the table definition permits nulls in the target table column. Optionally you can:

Change the Sort order of a column.

Click the New button and select a column name from the dropdown, to add a column to the index.

Select a column and click the Drop button to delete the column from the index.

Select a column and use the arrow buttons to reorder the columns in the index.


Lets you work with settings in the following categories:


In addition to displaying identifying information, you can modify the Build Online and Max degree of parallelism properties. For details on these properties, see Indexes Wizard (SQL Server).


Lets you set Index Type, Clustered, Ignore Duplicate Key (for Index Type of UNIQUE), Statistics Recompute, Allow Row Locks, and Allow Page Locks properties. For details on these properties, see Indexes Wizard (SQL Server). NOTE: You cannot reorganize an index (primary key, or unique key) that has an Allow Page Locks property set to FALSE. For information on reorganizing indexes, see Reorganize (SQL Server indexes, primary keys, and unique keys).


Lets you set Partitioned, Partition Scheme, Parttition Column, Fill Factor, File Group, Pad Index, and Sort in Tempdb settings.


Lets you view statistics in the following categories:

Page Statistics

Data Pages, Reserved Pages, Used Pages, and Total Pages Modified.

Row Statistics

Maximum Row Size, Minimum Row Size, Max Size of Non-Leaf Index Row, and Total Rows Modified.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.