index

[Former Member]

what is meant by index of table or an internal table

[Former Member]

check...

www.erpgenie.com/abap/index.htm

www.geocities.com/SiliconValley/Grid/4858/sap/ABAPCode/index.htm

www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/abapindx.htm

[Former Member]

Hi,

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

[former_member196280]

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

Regards,

SaiRam