Use of Parameterization on SQL Database for Exact MAX

 

In some cases setting the database Parameterization setting may increase performance of MRP Explosion and other sizable batch processes. Testing this in your test environment is definitely recommended. Change this setting under options in your SQL database and benchmark the change in processing time.

Leave a Reply

Your email address will not be published. Required fields are marked *