.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