Performance issue

[Former Member]

Hi ,

I am accessing table mseg . But the condition is such that i cannot use the key fields . The field that i can use is CHARG wich is not a primary key . In run time analysis the database usage is going near to 35 % . Is their any solution to reduce the database usage % .

Neetesh

[Former Member]

Here are some of the steps which might help you to improve the performance of your program ...

refer

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp

Regards,

Santosh

[Former Member]

Hi Neetesh,

creating an index will help in improving the performance.

u can use ST05 to know the select statements causing performance problems. then tune the same

if you are using for all entries, see u have deleted the duplicate entries and check if the internal table is initial prior to that.

u can go throught the below blog for more details:

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap%2bperformance%2band%2btuning

regards,

madhu

[Former Member]

Hi Neetesh,

The best way to improve performance is to create index on CHARG field. But SAP suggests no more than 3 indexes for a transactional table and no more than 10 for a master data table. So take care of the existing Indexes.

Other things you can keep in mind are

In the select query the order of selected fields should be same as in the table.

In where condition also keep the order of fields same as in the table

if you are selecting data from for some values in an existing internal table then sort that internal table in order as mentioned in where clause and dontr forget to check table not initial before select query.

Reward points if helpful

Regards,

Pankaj Sharma