How to place an existing index on a different filegroup (Enterprise Manager)

How to place an existing index on a different filegroup (Enterprise Manager)

To place an existing index on a different filegroup

1. Expand a server group, and then expand a server.
   
   
2. Expand Databases, expand the database in which the table containing the index belongs, and then click Tables.
   
   
3. In the details pane, right-click the table, and then click Design Table.
   
   
4. Right-click any column, and then click Properties.
   
   
5. On the Indexes/Keys tab, in the Selected index list, select the index to move.
   
   
6. In the Index Filegroup list, select a filegroup on which to place the index.

See Also

Placing Indexes on Filegroups