Indexes Dialog Box

(Microsoft SQL Server 2000 only.) Allows you to create, delete, and modify indexes. This dialog box applies only to views.

Selected Index

Shows the name of the first index for the selected view. To show properties for a different index, select an index from the drop-down list.

New

Choose this button to create a new index. For more information, see Create Indexed Views.

Delete

Choose this button to remove the selected index.

Index Name

Shows the name of the selected item. You can rename the item by entering a new name in this box.

Column Name/Order

Shows the columns contributing to the index, 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.

Index File Group

Select the name of the file group in which you want to store the selected index. You must have at least one user-defined file group for this setting to be enabled. This setting is only available for Microsoft SQL Server 7.0 or higher databases. 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.

For more information on creating and using file groups, see your SQL Server documentation.

Create UNIQUE

Select this option to create a unique index for the selected view.

• Ignore duplicate key    If you create a unique index, you can set this option to ensure each index value is unique.

Create as CLUSTERED

Select this option to create a clustered index for the selected view. For more information, see Create a Clustered Index.

Do not automatically recompute statistics

Select this option to tell SQL Server to use previously created statistics. This choice, available only for SQL Server 7.0 and higher databases, may not produce optimal results and is not recommended.

For more information, see your SQL Server documentation.

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. For more information, see Specify a Fill Factor for an Index.

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.