Question
Fix the performance issue
.Hi
please help me with this Thank you.
Identify the cause of the performance issues in this query. See the attached DDL’s of each table.
Explain how to fix the issue.
SELECT "PC0".pxUrgencyAssign AS "pxUrgencyAssign" , "Eval".pxCreateDateTime AS "pxCreateDateTime" , "PC0".pxTaskLabel AS "pxTaskLabel" ,
"Eval".LoanIdentifier AS "LoanIdentifier" , "PC0".pxRefObjectInsName AS "pxRefObjectInsName" , "Eval".pyStatusWork AS "pyStatusWork" ,
"PC0".pzInsKey AS "pzInsKey" , "Eval".EvaluationType AS "EvaluationType" , "Eval".EvaluationIntent AS "EvaluationIntent" ,
"Eval".InvestorEntityName AS "P148477886442110L" , pega.pegaDATA.pr_read_from_stream('.InvestorLoanInformation.InvestorCode', "Eval".pzInsKey, "Eval".pzPVStream) AS "P148477886442111L"
FROM pega.pegaDATA.pc_assign_workbasket "PC0" INNER JOIN pega.LossMit.EvaluateApplication_Work "Eval" ON ( ( "PC0".pxRefObjectInsName = "Eval".pyID ) AND "Eval".pxObjClass LIKE 'CPU-CLS-MSERV-LossMit-Work-EvaluateApplication%' AND "PC0".pxObjClass = 'Assign-WorkBasket' )
WHERE ( "PC0".pxAssignedOperatorID = 'EvalWaitforDecisionWB' ) ORDER BY 2 DESC
Hi srivatsavs,
You might want to look at exposing the column that is in the blob so it doesn't have to extract it each time using pr_read_from_stream.
https://pdn.pega.com/community/product-support/question/optimization-property
In addition, work with your DBA to validate proper indexes are in place.