Following standards should be followed to improve the performance. 1. Av

What is performance tuning?

Question Posted / manojkumar kotti

4 Answers
8032 Views
I also Faced
E-Mail Answers

Answer Posted / 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.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to combine multiple order in one Delivery ( Step by Step)?

2365

What is personnel sub are

2029

Differentiate database index and match code.

1109

Hi every one ! You people are doing a great job here , Im going to attend Tata Technologies interivew on this sunday,Can anyone who has already attended this company interivew or other companies interivews in abap pls share ur experience with me and help me to get into job my id ushareddyabap@gmail.com. Thankyou verymcuh

1897

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?

1045

A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain?

1409

Difference between stand alone CRM and back-end CRM

4260

What are the different types of parameters? How can you distinguish between different kinds of parameters?

954

What is the function of a domain?

1177

What are the different control break statements available inside a loop?

995

Explain the different types of data dictionary objects?

965

Can we use on change of between select and endselect?

1030

How can an internal table with header line and one without header line bedistinguished when passed to a subroutine?

1036

Define abap/4 layer?

1298

What is the different type of projects? : sap abap hr

893