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. de artículo: 4038595 - Última revisión: 07-08-2017 - Revisión: 1