What Methods are using in Perform tuning

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a report?

735


how to combine the transparent table with cluster table.

1087


Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?

580


What is a logical database?

660


What is the difference between a pool table and a transparent table?

530






Can i Have Some Realtime Examples on Badi ?

8268


Find the scenario and give the result: a, b, c are employees, where a, b will get basic, hra, da. C gets basic and da. How to group for the allowances? : sap abap hr

623


How do you find if a logical database exists for your program requirements?

630


can i use table key and key in an internal table and explain the functionalities of each one and what functionality does it give if both are used for same internal table

1775


what is a text table ?

1800


ABAP : Classical reports events name

889


Badi concepts

912


Explain what is runtime analysis?

556


What is open sql?

564


What are the function modules that are generated when you activate a lockobject? : sap abap data dictionary

558