Skip to Content
0
Former Member
Nov 20, 2008 at 10:34 AM

ERP6.0/10g performance problem

19 Views

Dear development support,

We have severe performance problems in several standard functions which access large tables such as GLPCA and MSEG.

[PROBLEM DESCRIPTION]

We are currently upgrading 4.6C system to ERP 6.0.

Program RCOPCA02 takes more than 10 minutes in our ERP 6.0 system, while the same problem finishes for about a few seconds in 4.6C system.

After our investigation, we found out the followings:

1. In 4.6C system, SQL execution plan shows that it's using add-on index

2. In ERP 6.0 system, SQL execution plan shows that it's using standard index (~1)

3. GLPCA table is analyzed and statistics information is updated

We want to solved this problem without adding any additional index because this table is very huge.

Thank you very much for your support in advance.

Regards,

Fukuoji