How to place an existing index on a different filegroup (Enterprise Manager)
To place an existing index on a different filegroup
- Expand a server group, and then expand a server.
- Expand Databases, expand the database in which the table containing the index belongs, and then click Tables.
- In the details pane, right-click the table, and then click Design Table.
- Right-click any column, and then click Properties.
- On the Indexes/Keys tab, in the Selected index list, select the index to move.
- In the Index Filegroup list, select a filegroup on which to place the index.