How to specify a fill factor for an index using a database diagram (Enterprise Manager)

To specify a fill factor for an index using a database diagram

1. Open a database diagram.
2. Right-click the table for which you want to specify a fill factor, and then click Properties.
3. Click the Indexes/Keys tab.
4. Click the index in the Selected index list.
5. In the Fill factor box, enter a percentage between 0 and 100.

See Also