joseph

• Aug 29th, 2005

 

i used performance tuning 
se30 
is the transaction code

Satya Krishna

• Sep 12th, 2005

 

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

KALI PRAMOD

• Dec 11th, 2005

 

use T-code SE30 for performance tuning

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

Harshal

• 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?

m_manic

 Profile Answers by m_manic Questions by m_manic

• Nov 25th, 2009

 

1. Avoid nested select statements
2. Do not use select statements inside loop.
3. Use all key fields in where conditions
4. select only nececessary fields.

surendra

• Oct 30th, 2014

 

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

Rakshitha Gangatkar

• Jun 3rd, 2015

 

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

Sherif

• 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.

Varun

• 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.

thejaswi

• Mar 24th, 2016

 

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

Narasimha

• 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....
else.
exit.
endif.
endloop.

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