What Methods are using in Perform tuning
Answers were Sorted based on User's Feedback
Answer / pnrao.abap
Select Statement
Inner join
Subroutines
Debugging Techniques-Watch Point
- Breack Point
Runtime Analasys-SE30
SQL Trace-ST05
Data browser-se16
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / venkata ramamohana rao s
in select statement mainntain the list of field of what do
u want to fetch the information from DB instead of "select
* " and mention the primary key in where condition ins.
remove select and endselect statement.
using FOR ALL ENTRIES.
remove the nested loops.
never maintain the select statement between the loop.
remove the move-corresponding statement.
using select single
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / raghunath
check the select statements and use all the key fields in
the select statement.
Try using for all entrie where ever possible
Avoid select end select statement
Avoid select statement in a loop
use run time analysis nd try to redude the data base time
as low as possible.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / supriya
1. Should be the sequence of fields in Internal Tables n in
SELECT statement same as Database table fields sequence, 3
of the sequence should b same.
2. Try to use SELECT SINGLE statement
3. Always use BINARY SEARCH
4. Make use of Primary keys
5. Use ST05, SE30, SQLTrace
6. Avoid SELECT statement in Between LOOP ENDLOOP.
Is This Answer Correct ? | 1 Yes | 0 No |
PROGRAM TO CREATE INQUIRY IN SD USING BAPI 'BAPI_INQUIRY_CREATEFROMDATA'
If we put Top of Page in between Start-of-selection and End-of-selection and what happenes
in an interactive report i want to trigger both 'at line selection' and 'user command'....if possible then how?
how to handle events in classical reports?
Explain the difference between function group and function module?
Explain the difference between call screen and leave screen?
What are the advantages of logical databases?
Explain how to write a bdc - how do you go about it?
How to debugg script?
What are the include programs?
layout conversion?
what is the difference between at line selection and at line selection on field.