secondary index

[Former Member]

Hi all,

What is secondary index? pls give with an example.

thanks

[Former Member]

Primary index: the primary index contains key fiels of a table and a pointer to non-key fields of the table. The primary index is created automatically when a table is created in database and moreover you can further define reference to the primary index which are known as Secondary index.

How many indexes can be created for a table? -> 9

When you are selecting the data on non primary key,obviously system will give output with bad performance ,if you create secondary index then it gives better performance

Thanks

Seshu

[Former Member]

Thanks Seshu,

how to create a secondary index?

[Former Member]

GOTO SE11 -> give ur table name -> click on display button -> click on index button ->click on create button -> give id ( z98 like ) -> give field names MANDT ,then ur field names

save and activate

Thanks

Seshu