srivatsav sagari (srivatsavs)
Infomatics Systems Inc

Infomatics Systems Inc
srivatsavs Member since 2017 3 posts
Infomatics Systems Inc
Posted: March 1, 2018
Last activity: March 2, 2018
Posted: 1 Mar 2018 14:15 EST
Last activity: 2 Mar 2018 9:05 EST

Fix the performance issue


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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.