Class Joins in Report Definition

General
, ,
1

Hi Guys,

I am joining multiple classes and applying filters across both. The performance is very poor. How would I analyze and optimize the report?

Regards,

Niharika

2

@DADIN007

Take the SQL from the tracer and run it the query inspector. See which fields are returning higher costs, those columns you need to index.

3

@DADIN007

You can run PAL(Performance analyzer) and Performance Profiler which gives you an idea of which execution is taking time.

4

@DADIN007

To analyze and optimize a slow report in Pega with multiple class joins:

  • Use Tracer and Performance Analyzer to inspect SQL queries, execution time, and joins.

  • Limit the number of selected columns and avoid unnecessary embedded properties.

  • Apply filters on indexed properties and use simple conditions (=, >=) instead of complex functions.

  • Avoid unnecessary joins; use Declare Index or sub-reports where possible.

  • Enable pagination to reduce load, and avoid SELECT * queries.

  • Use EXPLAIN PLAN (if possible) to analyze SQL and ensure indexes are used efficiently.

Regards,

Mamatha Adiraju