Customers with large data set running advanced wearehousing, experience slow performance when running on-hand queries.
Performance of the on-hand form where different items or dimensions can be displayed and can have very different data distributions, is impacted when SQL server re-uses a query plan.
The stored procedure that calculates the on-hand have Options added.
This is done to mitigate situations where data distributions lead to issues when SQL re-use query plans that were optimal for one items data but not for other items.
Article ID: 4038595 - Last Review: 2017, ഓഗ 7 - Revision: 1