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 clustered tables?

703


How will u handle the situation – In a report using function module to generate a IDOC, How will u handle the error IDOC in the same report ?

1769


How many tables are there in sap?

739


How do you find out who has transported a transport request?

696


Can anyone done BDC/LSMW/BAPI for F-02 and F-04.If yes let me know the processs

2039






Some Realtime Examples on Exits .

1816


Differentiate between table and template ?

695


Find the scenario and give the result: a, b, c are employees, where a, b will get basic, hra, da. C gets basic and da. How to group for the allowances? : sap abap hr

744


Application Category?

1001


In sap script how to print bar code in vertical manner

3534


What happens if a function module runs in an update task? : abap modularization

683


Explain the different types of view?

706


What are control tables? : abap data dictionary

679


What are the different functions used in sap script?

607


Do we have to migrate all sapscript forms to smart forms?

699