Showing results for 
Search instead for 
Did you mean: 


Former Member
0 Kudos

what is meant by index of table or an internal table

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos
Former Member
0 Kudos


Primary indexes are existing indexes we can use directly those indexes. we need to create the secondary indexes. In tables we will use both primary and secondary indexes.

Create secondary indexes step by step procedure.

1. Secondary index is created to enhance the performance. If you create wrongly defined index, it will decreases the performance.

Follow the below steps to create secondary index.

A.Go to t_code (se11) display your table name.

B.To create new index, click on index button on tool bar.

C.Give the index name.

D.Pass short text description for your index.

E.Bottom of the table pass field names on which you want index.

F.Save and activate.

2. You can create up to 16 indexes. But 5 is recommended...

Reward points if useful.

Thanks & Regards,

Vasudeva Rao

Active Contributor
0 Kudos

Index is mainly used for faster retrival of data.

1) primary index --> key fields of table

2) secondary index --> this can be with key or non-key fields