06-26-2008 8:38 AM
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
06-26-2008 12:25 PM
Hi,
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.
regards,
madhu