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

What data is contained in data dictionary? : abap data dictionary

1090


What are the data types of internal tables?

1068


Fallback class

2222


If I want to execute a bdc program only in background not in foreground is there any option for this? : abap bdc

1056


Concepts of OO ABAP and why we are using it?

1397


What is the difference between bdc_okcode and bdc_cursor? : abap bdc

1088


What is the company code? : sap abap hr

1073


What is the tcode to create indexes?

1011


What is pretty printer?

1022


What is a data dictionary? : sap abap data dictionary

945


What does the extract statement do in extract datasets? : abap modularization

1063


What is tcode se16? For what is it used.

1094


What are user exits? What is involved in writing them? What precations are needed?

1044


In selection screen, I have three fields, plant material number and material group. If I input plant how do I get the material number and material group based on plantdynamically?

1070


What is open sql?

1180