How to create index in your table

How to create index in your table

Step 1

To create an index in your table, open Enterprise Manager and then under Tools choose Wizard.

A new window will appear and then choose Create Index Wizard

Step 2

Create Index wizard will appear

Step 3

Click Next to continue

Step 4

We will set the Demo as the database and Employee as the tablename. Click Next to continue.

Step 5

Check on Employee_id to include it in index. Click Next to continue.

We will create a cluster index here.

Step 6

Fill factor determine the maximum value before extending it into another page. We will choose Optimal and then click on Next to continue.

Step 7

We will keep this as Employee_Index_1 and click Finish to complete it.