Question

1
Replies
63
Views
Close popover
Sai kishore Kandoori (kishore1505)
PEGA
Senior Solution Engineer
Pegasystems Inc.
IN
kishore1505 Member since 2017 3 posts
PEGA
Posted: August 5, 2020
Last activity: August 5, 2020
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