Answer / medepalli.sunil@gmail.com

If the report is taking time to fetch data from the database
server we have to make sure that there is an optimized
"query". In order to have an optimized query we need to
write an optimized "where" conditions. That's database part.

Coming to the Programming part.

Say example. Our program has the usage of 95% and the
database usage of 5 % then we have to see the program's
performance. Try to reduce the number of LOOP's in a program
and also try to use the logical operators where ever
necessary to reduce the size of the program . that could
solve the problem.

Answer / jesuvin

Performance of reports could be increased by avaioind nested
select statements. Instead use Select ... FOR ALL ENTRIES.

Restrict the use of Select... Endselect, instead go for
select .. inot table itab and then loop at itab.

Avoid nested loop statement, Do not use select within loop.

Do not call function module within loop statement.

Answer / sreedhar

use performance tuning steps to get good performance of ur
program.

Answer / venkateswarlu.bandi

Hi this is venkatesh,
this is my answer.
if it is too big means that is submitted into the
background processing.
that is which is using the standard program RSBDCSUB.
that is done by go thorugh transaction code is sm35.

atually all large programs are done by the background
porcessing only.

What are the disadvantages of abap query tool?

0 Answers  

---

Have you processed BDCs ?

0 Answers  

---

Difference between the sub-routines and function modules

2 Answers  

---

what is actaul procedure of session method of bdc. pls me complete steps.

4 Answers   Accenture, IBM,

---

How many domains will create for one data element?

2 Answers   IBM,

---

---

how many types of table types ?

4 Answers  

---

what are the components of bdc?

2 Answers   Accenture,

---

Explain badi in abap.

0 Answers  

---

suppose i want to print sap script output in different printers at a time what are the settings i'll have to make?

0 Answers   Colgate,

---

Define alv programming in abap?

0 Answers  

---

Define batch input session?

0 Answers  

---

THANKS ALL. i CLEARED THE INTERVIEW OF INFOSYS BASED ON THIS QUESTION SET. IT REALLY WORKS. LONG LIVE ALLINTERVIEW.COM

0 Answers  

---