Creating a secondary index

There are two types of indexes: Primary index and secondary index. Primary index is automatically created using the primary keys defined. 

Secondary index could be created as per the user requirement. This article discusses about creating a secondary index. 

Go to transaction SE11. 

 

For our demo purpose, we have considered the table ZAUTHOR. 

To know if there are any secondary indexes available, click on Goto - Indexes

 

Click on Create à Create Index 

 

Enter the name of the index. 

 

Fill in the details – Short description and the fields in the index. 

 

Save and activate. 

Now you can observe the index created.

  

Maximum number of secondary indexes we can have are 9.