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.
ID do Artigo: 4038595 - Última Revisão: 07/08/2017 - Revisão: 1