You are running a report. It is taking long time for
execution. What steps will you do to reduce the execution time.

Answer Posted / venkateswari

in this u should n'tuse select *
do n't use nested selects
do n't use nested loops
do not use select and end select
do n't use use select query in a loop

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi,how to diable the popup window which is displayed afetr executing the SAP script program?

1810


how to Create reports in SD module such as sales order report, which covers all organization levels, delivery status, invoice status, shipping details and partner function details. The data will be extracted from VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, LIPS, VBRP, MARA, VBEP and KONV tables. plz mention the detail coding Tahnks, Rahul

3101


What is the procedure you followed to upload the data?

764


What are the system table used in abap?

831


In the MM module for finding out the standard cost what is the view one has to look at?

822


What do you do when the system crashes in the middle of a BDC batch session?

933


In the `select' statement what is group by ?

1708


Did you create help views?

758


How to combine multiple order in one Delivery ( Step by Step)?

2178


Why do we use dynamic where conditions?

1112


Explain the call transaction method? : abap bdc

805


Can you define a field without a data element? : abap data dictionary

861


Why lsmw does not support call transaction method? : abap bdc

845


How can you find the field/data underlying a transaction?

816


Difference between Field groups and internal tables?

830