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

Performance issue in Select Query on ERCH

Former Member

‎2011 Jun 29 3:54 PM

0 Likes
494

Dear Friends,

I have to execute a query on ERCH in production system having around 20 lakh data which keeps on increasing. "Select BELNR VERTRAG ADATSOLL from ERCH where BCREASON = u201803u2019 " . The expected volume of data that the query will return is approx 1400 records.

Since the where clause includes a field which is not a key field please suggest the performance of the query so that it doesn't time-out.

Regards,

Amit Srivastava

Dear Friends,

I have to execute a query on ERCH in production system having around 20 lakh data which keeps on increasing. "Select BELNR VERTRAG ADATSOLL from ERCH where BCREASON = u201803u2019 " . The expected volume of data that the query will return is approx 1400 records.

Since the where clause includes a field which is not a key field please suggest the performance of the query so that it doesn't time-out.

Regards,

Amit Srivastava

Reply
1 REPLY 1
Read only

Former Member

‎2011 Jun 29 4:09 PM

0 Likes
396

Hello Amit Srivastava ,

You can add the Contract account number(VKONT) and Business Partner number(GPARTNER) in your query and can create a custom Index for the contract account number (We have this index created in our system).

This will improve the performance effectively.

Hope this answers your question.

Thanks,

Greetson