index id

[suhas_khengle2]

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

[Former Member]

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]

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]

Thanks