ddic

[Former Member]

i want brifely about what is an index in ddic and what is secondary index?

[JanStallkamp]

Ask in the DDIC forum or better just search for it.

Best regards,

Jan Stallkamp

[swathi]

hi

Index is a sorted copy of selected database table fields.It helps to speed up the selection of rows.There are two types of indexs

Primary Index :-Its a unique index constructed from the key_fields of primary key,its automatically created while creating a db table

Secondary Index :- It contain both key and non-key fields,its creted by the user,created alongside the primary index,it 's improve the performance of database reads performed on the indexes of the database.