Answer / manojkumar kotti

Following standards should be followed to improve the performance.

1. Avoid using * in select query.
2. Avoid using move corresponding.
3. Avoid using nested selects.
4. Avoid using nested loops.
5. Avoid using select query within loops.
6. Try to use the primary key with select query based on the requirement.
7. Fields in the select query should be in the same order as existing index
8. Avoid using delete statement within loops.
9. Use binary search clause with read statements.
10. Avoid using appending corresponding fields clause.

Regards,
Manoj.

Answer / ajay kumar

Performance tuning means analyising the performance of the
program.

Performance of the program depends on the data transfer.

By reducing the amount of data to be transfered, we can
improve the performance of the program.

Answer / niranj

increasing effeciency of programs thru optimized coding
eg : select ... table itab...
instead of
loop at itab

select ,...into itab..
endloop

Answer / lavanya

Performance tunning.

There are various steps to increase the performance of ABAP
report.

* should not use * in the select query ,instead use the
appropriate field names.
* In the occurs clause avoid using 0 instead use the number.
* try to use move-corresponding .
* use the aggregate statement.

what is Composite key in table creation? what is the use?

1 Answers   Wipro,

---

what is meant by enhancement category?

1 Answers  

---

What is updated Function Module.

3 Answers   IBM, Intelligroup,

---

What are the function of the transport system and workbench organiser? : abap data dictionary

0 Answers  

---

DO SERVERS IN EVERY COMPANY HAVE A SPECIFIIC NAME CAN I KNOW THE SERVER NAME OF IGATE AND ITS GEOGRAPHICAL LOCATION AND HOW MANY SERVERS DO A COMPANY WILL HAVE FOR SAP

3 Answers   Verizon,

---

If yes then why do we require logical database

0 Answers  

---

Suppose the client wants me the vacancy to be displayed on a website as well as ess. How should I do it? : sap abap hr

0 Answers  

---

17) How will you validate selection screen elements?

3 Answers  

---

What are the general naming conventions of ABAP programs?

1 Answers  

---

What are Major differences in Smart forms and Scripts

1 Answers   HP,

---

What do you mean by cluster tables in sap abap? Also explain what do you mean by table cluster? : abap data dictionary

0 Answers  

---

Can i know some of the Realtime tickets that anyone has been faced ?

0 Answers   SAP Labs,

---