Question

1
Replies
1260
Views
Close popover
srivatsav sagari (srivatsavs)
Infomatics Systems Inc

Infomatics Systems Inc
US
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,
Close popover 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.