Dear development support,
We have severe performance problems in several standard functions which access large tables such as GLPCA and MSEG.
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.