August 03, 2013

Huge InventSumLogTTS table

Query:
How to fix the performance issue due to the huge InventSumLogTTS table?
Answer:
When you run Master Planning, the InventSumLogTTS table enables Master Scheduling to be updated based on the changes to transactions. After Master Scheduling runs, the records in the InventSumLogTTS table are deleted. When Master planning license is present and configuration turned on, the master planning execution should clean this log periodically. But when this is seldom used, the cleanup will be less frequent contributing to the growth of the table.
If you are running master planning on a regular basis then this table will get cleaned up.

-Harry

No comments:

Post a Comment

Thanks

Note: Only a member of this blog may post a comment.