difference between primary index and secondary index.when we
use secondary index in reports?

Answer Posted / sivaramakrishna

when we want to get the details based on a field in select
statement we should use always primary key fields to
improve the performence. but in any case needed to get
detais based on non primary key fields then we go for
secondary index . ie based on which non primary key fields
we need to fetch the data using select st for those fields
we create secondary index in sell.

Is This Answer Correct ?    15 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can a filed occur in several field groups?

764


Explain the advantages of logical databases?

773


In which table the material master data is stored?

741


out bound process code for quotation?

1723


What are the system fields?

714






How many default tab strips are there?

751


What are the two statements which are required in an abap program to output an icon using a write statement?

981


Badi concepts

1125


Setting up a BDC program where you find information from?

861


what is diff between ECC 5.0 AND ECC 6.0

3046


What is an rfc?

796


What are the client dependant objects in abap / sap?

695


When will the current screen processing terminates?

737


How can we set the table spaces and extent sizes? : abap data dictionary

980


Can you show multiple alvs on a single screen?

787