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 |
functional spec given by whom?
Parallel cursor
Can a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary
what is the difference between se16 and se17 ??? need urgent ans plz..
is it possible to insert records into structure? if yes means how many records can be inserted?
You have 5lakh records to transfer to sap from flat file.which method of bdc you wiil choose and why?
What are the client dependant objects in abap / sap?
loop 5 times. sy-tabix,sy-index. endloop. what is the output?
what is process code?
when do you need to create an internal table with header line ? and with out a header line?
what do u mean by occurs 0
Example of Pooled and Cluster tables ?