How to create an index on an existing table (Enterprise Manager)

To create an index on an existing table

1. Expand a server group; then expand a server.
2. Expand Databases, expand the database in which the table belongs, and then click Tables.
3. In the details pane, right-click the table, point to All Tasks, and then click Manage Indexes....
4. Click New....
5. In Index name, enter the name for the index.
6. In Column, select the column to appear in the index. Composite indexes can be created by selecting more than one column.
7. Optionally, select a column, and then click either Move Up or Move Down to change the order of the columns in the index.
8. Optionally, in Index options, select:
   • Unique values to create a unique index.
   • Clustered index to create a clustered index. If a clustered index already exists, this option is not available.
   • Ignore duplicate values to control what happens when an INSERT statement inserts multiple, nonunique key values into an index. For more information, see CREATE INDEX.
   • Do not recompute statistics (not recommended) to specify that index statistics are not automatically recomputed as the index is updated.
   • Filegroup to specify the filegroup on which to create the index. Click the name of the filegroup.
   • Pad index to leave space open on each interior node of the index. For more information, see CREATE INDEX.
   • Drop existing to delete any existing index of the same name before creating the new index.
   • Fill factor to specify how full SQL Server should make the leaf level of each index page during index creation. For more information, see CREATE INDEX.
9. Optionally, click Edit SQL... to view and edit the Transact-SQL statement used to create the index.

See Also