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
