Have you used performance tuning? What major steps will you use for these?

Showing Answers 1 - 12 of 12 Answers


  • Aug 29th, 2005

i used performance tuning 
is the transaction code

  Was this answer useful?  Yes

Satya Krishna

  • Sep 12th, 2005

The Main Transaction Code Involved in Performance Tuning is SE30-Run Time Analysis and ST05-SQL Tracer.

  Was this answer useful?  Yes


  • Dec 11th, 2005

use T-code SE30 for performance tuning

  Was this answer useful?  Yes

rajat dey

  • Feb 9th, 2006

first of all tunning can be done

in three ways .. disk i/o ,sql tunning , memory tunning,

Before tunning u have to get the status of ur database using

oracle utility called statpack , tkprof, then u should go for tunning

  Was this answer useful?  Yes


  • May 4th, 2006

In Performance Tuning. Suppose if you got that problem is in Loop. How to find which specific loop is giving problem? What is the method to find out OR Is there any tool to find out?

  Was this answer useful?  Yes


  • Oct 30th, 2014

All ways use for all entries...
mention the fields in proper way...
Instated of select* use select field names

  Was this answer useful?  Yes

Rakshitha Gangatkar

  • Jun 3rd, 2015

Use Collect instead of sum or looping tables to find total of fields.

  Was this answer useful?  Yes


  • Jul 11th, 2015

Using collect would get only the unique records..in such case the total might go wrong. the SUM would give the exact total required. Further Collect would be very helpful in collecting unique records while hashed table.

  Was this answer useful?  Yes


  • Nov 17th, 2015

Avoid Nested Loop. and Using Where condition with select query and avoid Corresponding field of and not using inner join more than with one table.

  Was this answer useful?  Yes


  • Mar 24th, 2016

1. Sort tables before READ
2. READ with Binary Search
3. Pass full key in WHERE clause of SELECT statements

  Was this answer useful?  Yes


  • Jun 22nd, 2016

1. Select statement fields and data base fields must same.
2. We must declare the structures of the internal must be specified all key fields
3. In for all entries must deleted duplicates
4. Must sort the internal table
5. When use read statement binary search is mandatory improve the performance
6. Try avoid the nested loops if Required we go for parallel cursor the method
7. Maximum try less entries in Main loop because ... ex
IT_VBAK Contain 10 entries but IT_vbap contain 50 entries . it write the loop ... loop at it_vbap into wa_vbap . read table it_vbak into wa_vbak with key vbeln = wa_vbak-vbeln. endloop. but here main loop is iterated 50 times but performance not good. we go for other alternative .
loop at it_vbak into wa_vbak.
read table it_vbap into wa_vbap with key vbeln = wa_vbak-vbeln.
loop at it_vbap into wa_vbap from sy-index.
if wa_vbak-vbeln = wa_vbap-vbeln.
here write some operation....

Above main loop iteration 10 times and use binary search use in read statement improve the performance.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions