Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

Performance MCHB & MSKA

Former Member
0 Kudos

Dear friends,

Here the volume of data in the subject tables is very huge and performance of reports are badly affected.

But, on observing the data in these tables, most of material batches for previous year is already disposed and showing zero quantity. So, most part of the table data is occupied by zero quantity batches.

Is there any way that i can eliminate these batches from table, or any other way i can improve the performance (other than archive).

Kindly suggest,

Praveen Lobo


Former Member
0 Kudos


add all these condition to restrict the entries from those 2 tables.

u can add date range. in mchb u can see the 'date of last change- laeda field'.

write an efficient query.