Performance Issue. Queries are performing poorly when using the view 'dwh_res_security_v' & 'dwh_inv_security_v'.
Steps to Reproduce:
Expected Results: The reports using the view dwh_res_security_v & dwh_inv_security_v should efficiently work.
Actual Results: The reports using the view dwh_res_security_v & dwh_inv_security_v for large customer never finishes .
Release : 16.0.0, 16.0.1, 16.0.2
Component : CLARITY DATA WAREHOUSE
DE63862
Workaround:
Targeted Fix in Release 16.0.3