Question

1
Replies
1231
Views
srivatsavs Member since 2017 3 posts
Infomatics Systems Inc
Posted: March 1, 2018
Last activity: March 2, 2018
Closed

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

System Administration
Moderation Team has archived post
Share this page LinkedIn