Degraded performance when using secured views in BIP reports
Summary:
Using a secured view (e.g., PER_PERSON_SECURED_LIST_V) in a BIP report results in a severe increase in the execution time of the query when ran by a user with a restricted security context.
Content (please ensure you mask any confidential information):
The query (see the code snippet below) executes in 0.992 seconds when logged in as a User A that does not have any roles that limit access by areas of responsibility or security contexts (in other words, the user can see the data for everyone).
However, executing the same query as User B - who has 14 Areas of Responsibility (AORs) all limiting their data access - results in a 1.965