what is secondary index?

Answer Posted / sushil jaiswar

When certain fields apart from the defined key fields are
used frequently in select query then for improving
performance related to data fetch, it is advised to create
secondary index, which serves as a mapping, but to keep in
mind the order of fileds in use should be same as defined
in secondary index.

According to me Secondary Index is nothing but if we have 2
tables.First table has primary key,and second table also
have primary key.Then the key of the second table is
nothing but Secondary Index of the First Table.
According to me Secondary Index is nothing but if we have
2
tables.First table has primary key,and second table also
have primary key.Then the key of the second table is
nothing but Secondary Index of the First Table.

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the two ways for restricting the value range for a domain? : abap data dictionary

523


Explain the Inportance of pa40? : abap hr

566


Mention what is alv programming in abap?

576


What are the different methods of passing data?

587


Explain different types of locks?

554






What is the collect statement?

655


What are the disadvantages of using explicit enhancement?

1363


How to convert the Unit for 'Distance' (The value from one Unit to another).

1430


What is a table pool? : abap data dictionary

593


Is there any method apart from bdc for data upload to sap? : abap bdc

603


Sal abap on hana interview

695


HOW TO DIFFERENT CALL TRANSACTION ON THE BASIS OF DOUBLE CLICKING ON DIFFERENT FIELD.

1768


What are the Control levels in internal tables?

578


How to eliminate duplicate entries in internal tables? : abap data dictionary

773


Can you delete a domain, which is being used by data elements? : abap data dictionary

802