Last activity: 12 Apr 2021 11:24 EDT
ABAC policy condition with One Of condition is running too slow in DB2
We have used ABAC policy conidtion with One of. The filtering criteria is working fine but the query has turned out to be too slow due to ABAC.
Using One Of internally is adding a function call to compare column values with that of CSV we passed in right side of condition in condition rule. Looks like the function is slowing down the query.
Without the function it takes a second but with function (ABAC enabled) it takes around 7 seconds.