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

Flag

Total Pageviews

Disclaimer

This posting is provided 'as is' with no warranties, and confers no rights. You assume all risk for your use. All entries in this blog is my individual opinion and don't reflect the opinion of my employer.

Please use Code with caution in production environment. I will not be responsible for any Goof ups.. Template images by 5ugarless. Powered by Blogger.