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 is a table cluster? : abap data dictionary

1214


Mention what is alv programming in abap?

1257


What is the difference between the function module and a normal abap/4 subroutine? : abap modularization

1228


How to define selection screen?

1170


function modules are also external subroutines. State true or false. : abap modularization

1140


What is runtime analysis?

1223


How many ways you can create table? : abap data dictionary

1056


Type casting and error handling

1493


can any one answer these questions 1)How do you convert non-character field to character field? 2)How do you work with semi colon separated files? 3)why cant we use normal function module for data transfer? 4)what is the structure of CTU-PARAMS? 5)can we use transfer dataset to transfer data in internal table?

2046


Power is interrupted while transferring data from internal table to application server. How will you determine many records are transferred in session method and call transaction method? : abap bdc

1350


What are authorization objects and what statement is used to perform an authorization check in an abap program?

1063


What are the different attributes that can be assigned to a variant?

1089


What are the dis-advantages of logical databases? : abap hr

1198


How to create user interfaces for lists?

1068


Which transaction code is used executing a report (type 1 program)? : abap data dictionary

1108