Creating and Managing SQL Scripts - Microsoft Business Intelligence Tools for Excel Analysts - page 206

2. Add a name in the Index Name box, choose the type from the Index Type drop-down list, and
specify if the index is unique by selecting the Unique check box.
3. Click the Add button and select the column or columns that should be part of the index.
4. When finished, click OK.
SQL Server creates your new index on the table. Creating indexes may take some time on
large tables.
Dropping an index
You can view your indexes by expanding the Indexes folder in SQL Server Management Studio. If you
want to delete an index, right-click it and choose Delete. The Delete Object window opens, as shown
in Figure 10-11.
Figure 10-11: Deleting an index.
Make sure the window lists the index you want to delete, and then click OK.