Close popover
Sagar Sinhar (SagarS89)
Wells Fargo Bank
Sr Software Engineer
Wells Fargo Bank
SagarS89 Member since 2017 6 posts
Wells Fargo Bank
Posted: October 23, 2019
Last activity: October 24, 2019

Report on descendant class instances- Performance impacts

On a report definition under Data Access tab, we have "Report on descendant class instances" with option to choose "Include all descendant classes".

When this report definition is run on a class group with multiple work types(sub classes) where all instances reside in the same work table, the query generated by Pega generates a condition in where clause like this:

Where pxObjClass IN ('ABC-WORK','ABC-WORK-A', 'ABC-WORK-B')

However, if the "Report on descendant class instances" is not checked, the where clause has something this along with other conditions added in report def.

Where pxObjClass like 'ABC-WORK%'.

The second option has likelihood of performing a full table scan and so we choose to use Option 1.

Is this the right way of implementing this?

And how are the classes present in 'pxobjclass IN' built by Pega? Is that something for which a different query runs?

***Edited by Moderator: Pallavi to update platform capability tags***

System Administration Reporting
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.