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 differences between a database index and a match code?

602


What is the difference between upload and ws_upload ? : abap bdc

677


what are the critical issues u face in ur project?

1971


What is match code? : sap abap hr

644


Explain enhancements

877






Can we specify the next screen number with a variable?

565


Difference between sap script and report?

750


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

727


What is an Unpack command?

640


when run my program in se38 it was showing output, when i take background execution and giving printer details it was shoing out put. but in SP01 when i give the Spool Request Number it was showing not yet processed entire page why it happens i dont know please give me a solution.

2081


Why do we use abstract class

1031


Explain what are the events used in interactive reports?

494


What is the differences between structure and table in the data dictionary in abap?

611


Sal abap on hana interview

713


What is the functionality of BIZTALK and how it handles the IDOC’s and how u will transfer the IDOCS to the BIZTALK ?

2238