topic Re: Performance issue with MSEG table in Application Development and Automation Discussions

Performance issue with MSEG table

Former Member — Tue, 25 Mar 2008 05:13:15 GMT

Hi all,

I need to fetch materials(MATNR) based on the service order number (AUFNR) in the selection screen,but there is performance isssue with this , how to over come this issue .

Regards ,

Amit

Re: Performance issue with MSEG table

Former Member — Tue, 25 Mar 2008 05:17:23 GMT

hi Amit,

MSEG is a cluster table and has huge data ... so Try including all the key fields while fetching the data to improve the performance...

Regards,

Santosh

Re: Performance issue with MSEG table

Former Member — Tue, 25 Mar 2008 05:30:43 GMT

Is there any other table so that i can hit before hitting mseg table for material based on service order .

Re: Performance issue with MSEG table

former_member251078 — Mon, 14 Apr 2008 16:08:49 GMT

Hi,

There could be various reasons for performance issue with MSEG.

1) database statistics of tables and indexes are not upto date.

because of this wrong index is choosen during the execution.

2) Improper indexes, because there is no indexes with the fields mentioned in the WHERE clause of the statement. Because of this reason, CBO would have choosen wrong index and did a range scan.

3) Optimizer bug in oracle.

4) Size of table is very huge, archive.

Better switch on ST05 trace before you run this statements, so it will give more detailed information, where exactly time being spent during the execution.

Hope this helps

dileep

Re: Performance issue with MSEG table

Former Member — Mon, 14 Apr 2008 16:39:58 GMT

not sure, what exactly ur requirement is,

but try aufk, aFPO tables..