INTERVIEW QUESTIONS SAP NETWEAVER ABAP DETAILS

Question: Have you used performance tuning? What major steps will you use for these?

Answer: i used performance tuning
se30
is the transaction code

i used performance tuning
se30
is the transaction code

Source: CoolInterview.com

Precautions to be taken while u write the program :(SE30 : For performance check)
Note: If we want to check the performance of your program goto SE30 Transaction Code
and select the program radio button and give ur program name and press execute button and see ur program result and click back that will take u to se30 Transaction code and press the analyze button and see ur program performance there
if it is green it is good if it is red ur program have poor performance.Try below rules to improve ur program performance.
1. Avoid using SELECT...ENDSELECT... construct and use SELECT ... INTO TABLE.
2. Use WHERE clause in your SELECT statement to restrict the volume of data retrieved.
3. Design your Query to Use as much index fields as possible from left to right in your WHERE statement
4. Use FOR ALL ENTRIES in your SELECT statement to retrieve the matching records at one shot.
5. Avoid using nested SELECT statement, SELECT within LOOPs.
6. Avoid using INTO CORRESPONDING FIELDS OF TABLE. Instead use INTO TABLE.
7. Avoid using SELECT * and Select only the required fields from the table.
8. Avoid nested loops when working with large internal tables.

kiran kumar.G
id:[email protected]
Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question