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

how to genernate 21 sencondary index

7599


What are the basic object types? : sap abap hr

799


what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?

1942


What is the function of the transport system and workbench organizer?

846


Filter badi and multiple used badi? Will the sequence matter of the badi implementation in case of multiple used badi?

1478






If yes then why do we require logical database

2879


What are data classes? What are the various data classes available for selection? : abap data dictionary

742


Final class

1226


What is a maintenance view? : abap data dictionary

753


Power is interrupted while transferring data from internal table to application server. How will you determine many records are transferred in session method and call transaction method? : abap bdc

943


What is check table?

756


How to split one Invoice into Multiple ( Step by Step)?

1906


What is runtime analysis?

797


What is the difference between sum and collect?

1110


Can you show multiple alvs on a single screen?

787