.Access this form by selecting the Tables node (within a database) on the
navigation pane, then
select the required table in the
object list and click
the manage indexes icon .
Name
Shows the name of the index.
Type
Shows the index or key object type for the selected table: index, primary key,
or unique.
File group
Select the name of the file group in which you want to store the selected index.
If you create a database object and do not specify its file group, SQL
Server will assign it to the default file group. Initially, the default file
group is the Primary file group.
Fill factor
Shows the fill factor that specifies how full each index page can be. If a fill
factor is not specified, the database's default fill factor is used.
Pad Index
If you specified a Fill Factor of more than zero percent, and you selected the
option to create a unique index, you can tell SQL Server to use the same
percentage you specified in Fill Factor as the space to leave open on each
interior node. By default, SQL Server sets a two-row index size.
Columns
Shows the columns contributing to the index, primary key, or unique constraint,
along with whether each column's values are arranged in ascending or descending
order within the item. You can add, change, or remove column names in this list.
You can also change the ascending/descending setting for each column.
Create UNIQUE
Select this option to create a unique constraint or index for the selected
database table. Specify whether you are creating a constraint or index by
selecting either the Constraint or Index option.
Ignore duplicate key
If you create a unique index, you can set this option to
ensure each value in an indexed column is unique.
Create as CLUSTERED
Select this option to create a clustered index for the selected database table.
Do not automatically re-compute statistics
Select this option to tell SQL Server to use previously created statistics. This
choice may not produce optimal results and is not recommended.