topic Re: Fetch in a custom table - ECC 6.0 in Application Development and Automation Discussions

Fetch in a custom table - ECC 6.0

Former Member — Fri, 17 Apr 2009 06:27:14 GMT

Hi,

There is a custom table, which has got nearly 50 lakhs entries. The report's performance was fine in 4.7 version. After SAP upgradation to ECC 6.0, the execution of the query takes more than 5 hrs, which was just 600 sec in 4.7 system. What could be the problem?

Note: Primary key is not passed in the select query's WHERE condition.

Thanks,

Dhanalakshmi M S

Re: Fetch in a custom table - ECC 6.0

Former Member — Fri, 17 Apr 2009 07:19:11 GMT

Please check the secondary indexes avaliable on the table.

Re: Fetch in a custom table - ECC 6.0

ThomasZloch — Fri, 17 Apr 2009 08:06:24 GMT

Please post the entire SQL statement here and any surrounding loops, along with the execution plan from tx ST05 if possible.

Did you upgrade the database system as well? Did you add new indexes to the involved tables?

Thomas

Re: Fetch in a custom table - ECC 6.0

HermannGahm — Fri, 17 Apr 2009 09:14:43 GMT

Hi,

was the database been upgraded as well? Have the statistics been updated after the upgrade?

As Thomas said, please post more details... execution plan, ST05 summary, variables, indexes, ... .

Kind regards,

Hermann