How to manage index

How to manage index

Step 1

Go to Enterprise manager, expand your database. In this case we are using Demo database and then right click Employee table that we have created earlier. When a popup menu appear, go to All task and then select Manage Index

Then another new window will appear as indicated below:

Step 2

To edit your Indexes, click on Edit. This will lead you to another windows as shown below:

Step 3

In this example we will modify the fill factor to 85. Just click on Fill factor and set the value to 85.