Skip to Content
0
Former Member
Jun 29, 2011 at 02:54 PM

Performance issue in Select Query on ERCH

52 Views

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