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 |
What is step-loop?
What is the effect on Customer Exits and User Exits maintained in a system on Up-gradation .
I want to display the different data on the multiple main windows of the form in Sapscript. Is it possible ? If yes, then How?
How do you know that data is updated in call transaction
While picking can the pick list be updated automatically?
How can I make a differentiation between dependent and independent data?
What is the sequential order of triggering events in interactive report?
there are 2 selection screens. material num in screen 200 and plant in screen 300. so how can you write in INITIALISATION event?
Hi to all abap guru's my querry is as follows How to trigger the page break in smartforms forcibly ? and how to trigger the page break in the scripts forcibly ? means for every 10 records i have to trigger the page break ? and in smart form also ? thanks in advance
how to find the report is classical or intractive report in debugging mode
how do you supress blank spaces in sap scripts?
What is the difference between open sql & native sql ?