Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / pradipta mahato

Hi,
Ideally we should follow following thing for good performane

1. Avoid select inside loop (select out of loop and read it
inside)
2. Avoid nested loop and unnecessary extra loop in code
3. Change loop to read if there is a chance
4. Avoid join better use 'for all entries'
5. read internal table using binary search ( Sort it first)
6. If select statement creating problem then index could be
created

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

PROGRAM TO CREATE INQUIRY IN SD USING BAPI 'BAPI_INQUIRY_CREATEFROMDATA'

4184


Can a domain, assigned to a data element be changed?

1043


Explain the difference between function group and function module?

1089


What are number ranges?

1001


what is call back in alv?

2406


what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.

2510


Can we create an abap program without using y or z?

1040


What is view? Different types of view.

1050


In sap script how to print bar code in vertical manner

3888


Why grouping of fields is required? What is the max no of modification groups for each field?

965


What is the difference between call transaction method and the session method? : abap bdc

920


What is the use of start-of-selection.,if not use in report what will happen,?

1633


What are the merits of its?-

1026


In se11 -->Tech. settings --> Data class. If I save table as Mater data OR Transaction data, what effect will it has for 'Storage' in Database after activation. or In Database how it will store in both the cases.

2534


What is a persistent class?

1378