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

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

513


Give 3 scenario of reporting due to which you require reporting help of ABAP consultant?

1664


How to get that a secondary index is attached to a select query?

939


How to handle errors in call transaction bdc method without using bdcmsgcoll internal table? : abap bdc

663


What is the difference between the function module and a normal abap/4 subroutine? : abap modularization

691






What are the table controls in bdc ? What is the difference between bdc and lsmw ?what is the difference between bdc and rfc ? : abap bdc

549


Can we set page headers to details lists?

584


What is a multiple line field?

587


Select up to 1 row and select single difference ?

643


Why do we use dynamic where conditions?

870


Differentiate between ooabap and abap?

699


What are the control break events in abap? : abap data dictionary

609


What is luw or data base transaction ?

571


hi,i worked mostly in core abap.know iam assigned to XI utility project.can u experts let me know what r the basic things i need to learn to work in XI utility project.i already searched in forum.thanks in advance.

1557


How many ways you can create table? : abap data dictionary

530