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 is bdc programming in sap?

814


What is the use of buffering?

753


How can an internal table with header line and one without header line bedistinguished when passed to a subroutine?

824


Can a constructor be redefined?

1112


when u prefer lsmw?

792


What is the difference between a structure and a table?

737


5) How to rereive text elements in SF and script?

1877


What is the difference between open_form and close_form?

815


What is an update type with reference to a match code id? : abap data dictionary

757


Can you assign a matchcode object to a parameter? If so how?

791


What are local objects? : abap data dictionary

797


Explain what is the significance of hide?

745


List the various components of the enterprise structure in systems, applications, and products (sap) in human capital management (him)? : sap abap hr

683


What is the difference between dialog program and a report?

817


what will happen if called program is not executable ?

1869