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

Explain different types of locks?

569


What is example class

888


What is the difference between a pool table and a transparent table?

544


What is buffering allowed but switched off?

869


Where do you use help views?

570






Explain how is batch input process different from processing on line?

559


What are the advantages/ dis-advantages of logical databases?

548


how to use table control?if suppose i have 6 records and i want more 4 records in sequence.How to handle this scenario?

1580


What is the role of ‘refresh’ in internal table?

592


What are the advantages and disadvantages of using views in abap programming ?

651


There is a delivery that is being created through the ABAP code and in the middle it says delivery created but someone is modifying , how would you rectify this issue

7591


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

1933


What are the two different ways of building a match code object?

592


What is the significance of technical settings (specified while creating a table in the data dictionary) ?

588


Explain the call transaction method? : abap bdc

592