Question

Pegasystems Inc.
IN
Last activity: 5 Aug 2020 4:18 EDT
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?