What secondary index and use of it and how many secondary index we can create?

Answer Posted / roy

Secondary index can be create based on the primary key or non primary key or only with non-primary key of a table.

Use of secondary key to fetch the data faster from the database.

We can create maximum 9 secondary index.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

there are 2 selection screens. material num in screen 200 and plant in screen 300. so how can you write in INITIALISATION event?

1853


What is meant by hot spots? : abap data dictionary

739


What is the difference between sy-tabix and sy-index? Where it is used?

865


What is the difference b/t Session method and call transaction method ??

5410


What is design pattern? Provide example .Why are we using it?

1094






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

689


wat are the process that can be executed & tracked in a workflow?

1757


Explain badi in abap.

674


What type of user exits have you written ?

1593


Event handling in oops

1218


What is the difference between call transaction and session method? : abap bdc

759


What is meant by performance analysis? Have done anything to improve the performance?

645


What are the difference between pool tables and transparent tables?

717


identify valid statement when coding a field exit ? a) submit RSCA101X b)MESSAGE E101 C)MESSAGE I101 d)BREASK-POINT

2097


Difference between top-of-page and top-of-page during at line- selection?

2034