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

What is projection view?

533


What is technically difference between in Table creation in table creation maintenance not allowed ,maintenance allowed with restriction, maintenance allowed ?

1157


What are the functional modules used in sequence in bdc? : abap hr

584


When will the current screen processing terminates?

541


What is web dynpro for abap?

563






What are the data classes in abap?

601


how to create view in bdc..??

2320


What is the project you are currently working and work that you are doing

1008


What are the functional modules used in sequence in bdc? : abap bdc

572


Where the payroll results are stored

1900


What are the events in ABAP language?

603


What work you have done in HR module

898


What is the lock object?

592


What are the buffering options in abap?

561


What are the mandatory fields to be filled for BAPI_CUSTOMER_CREATEFROMDATA1

2882