Execute the Transact-SQL script in the query pane.
In the result pane, click the ExecutionPlan tab.
Right-click the icon of the physical operator that suggests that an index needs to be created, and then click Manage Indexes.... The database and table that the Graphical Execution Plan suggests need an index are automatically selected. Click New....
In Index name, enter the name for the index.
In Column, select the column to appear in the index. Composite indexes can be created by selecting more than one column.
Optionally, select a column, and then click either MoveUp or MoveDown to change the order of the columns in the index.
Optionally, in Indexoptions, select:
Uniquevalues to create a unique index.
Clusteredindex to create a clustered index. If a clustered index already exists, this option is not available.
Ignoreduplicatevalues 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.
Padindex to leave space open on each interior node of the index. For more information, see CREATE INDEX.
Dropexisting to delete any existing index of the same name before creating the new index.
Fillfactor to specify how full SQL Server should make the leaf level of each index page during index creation. For more information, see CREATE INDEX.
Optionally, click Edit SQL... to view and edit the Transact-SQL statement used to create the index.