How to create a clustered index using a database diagram (Enterprise Manager)

To create a clustered index using a database diagram

1. Open a database diagram.
2. Right-click the table whose index you want to modify, and then click Properties.
3. Click the Indexes/Keys tab.
4. Click New.

   The Selected index list displays the system-assigned name of the new index.

5. Under Column name, click the columns to index.

   You can select up to 16 columns. For optimal performance, select only one or two columns per index.

6. Select the Create as CLUSTERED check box.

See Also