how will u write a report for performance point of
view ?
Answers were Sorted based on User's Feedback
Answer / rahul singh
1. Don't use the followings :-
a. loop within loop.
b. select endselct.
c. Occur (statements)
d. Move corresponding.
e. use of cluster tables.
f. use select * (all feilds)
g. use of OR statement in select statement.
h. use of negative conditions.
2. Use the following :-
a. loop with reads if needed to be read multiple time.
b. Use of IN statement in select statement instead of OR.
c. use of maxium key feilds with select statement.
d. use of function modules instead of select statement
if it is available.
Is This Answer Correct ? | 14 Yes | 0 No |
Answer / muralitharan
Additional to above points,
In select query Use For All Entries while pulling data from
database.
Frequently don't use inner join in your program
While Looping create work area and process the record
These are some points to improve performance of program
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / jc
1. Clear understanding of requirement.
2. Construct the how-to before actual coding starts.
3. Avoid using multiple read to the same database table.
4. Make sure to use indexed field while reading to database table.
Is This Answer Correct ? | 7 Yes | 2 No |
Can you assign a matchcode object to a parameter? If so how?
What are the advantages and disadvantages of using views in abap programming ?
What is the function of a domain? : abap data dictionary
What is For-period and In-period
Where do you use help views?
Describe the data classes?
Can a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary
How to modify the tables at Data base level?
Explain about interactive report?
What actually happens in real-time recruitment? : sap abap hr
What is the alternative to batch input session?
what connects smartform to it's driver program?