Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Fetch in a custom table - ECC 6.0

Former Member

‎2009 Apr 17 7:27 AM

0 Likes
536

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

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

Reply
3 REPLIES 3
Read only

Former Member

‎2009 Apr 17 8:19 AM

0 Likes
513

Please check the secondary indexes avaliable on the table.

Read only

ThomasZloch
Active Contributor

‎2009 Apr 17 9:06 AM

0 Likes
513

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

Read only

HermannGahm
Product and Topic Expert
Product and Topic Expert

‎2009 Apr 17 10:14 AM

0 Likes
513

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