Question

1
Replies
34
Views
kishore1505 Member since 2017 2 posts
PEGA
Posted: 1 month ago
Last activity: 1 month 3 weeks ago
Solved

Report that fetches specific values of a column along with null values is slow

We have a report definition where requirement is to fetch records with specific values in a column along with null values. Due to very huge data in the table (over 1.5 million records) & OR logic in the filter criteria it is very slow.

Say, distinct values of a property named ManagementLevel are Top, High, Medium, Low & null (database null, not string).

Filter condition in report to fetch needed results is A OR B

A is ManagementLevel equals "Low","Medium"

B is ManagementLevel is null

Is there a way to avoid this OR logic which does a full scan / union of results that is leading to slowness?

Pega Platform 8.5 Reporting Other Industry
Share this page LinkedIn