Question
AVANTHI INSTITUTE OF ENGINEERING AND TECHNOLOGY
IN
Last activity: 15 May 2025 7:28 EDT
Class Joins in Report Definition
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
Accepted Solution
Updated: 15 May 2025 7:28 EDT
AVANTHI INSTITUTE OF ENGINEERING AND TECHNOLOGY
IN
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
Maantic Inc
IN
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.
Tata Consultancy Services
IN
You can run PAL(Performance analyzer) and Performance Profiler which gives you an idea of which execution is taking time.
Accepted Solution
Updated: 15 May 2025 7:28 EDT
AVANTHI INSTITUTE OF ENGINEERING AND TECHNOLOGY
IN
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