Performance issues around calculation for 'PWODecisionRuleRulerDetect' table functions following an upgrade to One Identity Manager 7.1.3 or 7.1.4 (4318037)

Following an upgrade to One Identity Manager versions 7.1.3 or 7.1.4, calculation of task QER-K-ShoppingRackPWOHelperPWO can be slower for customer-configured decision rules, under certain circumstances.

Prior to the implementation of feature 28471 in version 7.1.3, PWODecisionRuleRulerDetect table functions were created as multi-statement table-valued functions, but only ever returned one statement's result set with it.  In such instances an inline table-valued function is more favourable because it allows for SQL server to include table statistics.  SQL Server can then use an optimized execution plan.  An example for a discussion around this can be found here: Comparing Inline and Multi-Statement Table-Valued Functions.

However, in some instances, when customer statements for ruler detection were not performing well, the optimized execution plans from the inline table-valued functions performed worse than the non-optimized execution plans for the multi-statement table-valued functions.

A common example for such statements is when customers used a comparison of UID values, which are Varchar columns since version 7.0, against NVarchar strings. This could be a leftover of statements that customers configured in version 6.1 or earlier.

In general, One Identity recommend revisiting customer SQL statements, e.g. custom approval procedures or CD conditions, but also statements from the web portal or in dynamic roles, with major upgrades.  Thus far the reported occurrences were not revisited between versions 6.1 and 7.x.