Hi,
We have a live report queried on LLATTRDATA table with "Filter Permissions" parameter which is taking quite long time to retrieve the results for business users. We checked the query without this "Filter Permissions" condition is not taking much time and results are appearing within few seconds, but whenever we include this parameter, it's taking more than 1.5 minutes of time to get the results. Hence we are trying to optimize this to reduce the wait time for business users. We even added below indexes on DTREEACL table.
Please find the attached exported livereport and can someone help us with suggestions to optimize based on the permissions with minimal execution time of the report.
Thanks!
