Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

index id

suhas_khengle2
Explorer
0 Kudos

What is an index id. ? It is 0 for primary index.

3 REPLIES 3

Former Member
0 Kudos

The three-place index ID uniquely identifies an index within a table.

The index ID may only contain letters and digits. The ID '0 ' is reserved for the primary index. The name ranges 'Y..' and 'Z..' are reserved for customer indexes.

The index name in the database comprises the name of the table and the index ID. The table name and index name are separated by the character '~' (or the character '^').

Reward if useful

Regards

Prax

former_member196280
Active Contributor
0 Kudos

Index is mainly used for faster retrival of data..

Ex: similar to an Index in a book

IN SAP we have two different indexes

1) Primary Index

2) Secondary Index

Primary index is created automatically when you set key fields in the table,

Secondary index, can be created on different fields using key fields and non key fields or only non key fields, you have an option in menu for creating secondary index.

Regards,

Sairam

suhas_khengle2
Explorer
0 Kudos

Thanks