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

What are the domains and data elements?

1224


What are the different types of operators in the sap abap?

800


What is the different type of projects? : sap abap hr

704


What is the difference between Check and Continue?

884


How do you move on to the next screen in interactive reporting?

918


What are the pooled and cluster tables?

786


Explain the advantages of different types of bdc's?

769


What functions does a data dictionary perform? : abap data dictionary

840


Select query optimisation

1121


What are internal tables? How do you get the number of lines in an internal table?

889


What is a persistent class?

1181


Explain the difference between a pool table and a transparent table and how they are stored at the database level?

805


What are the Synchronous and asynchronous methods in bdc ?

845


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

945


i have executed a report via back ground job, in this report i have used enqueue and dequeue function modules on a table, but before releasing the lock(before dequeue function module is not call) job gives the dump, so the lock is not released the table, here my question is how to set the lock automatically release the there is a short dump before calling the dequeue module?

1960