What's new in Customer Journeys?

Connect and learn more!
Help with Query optimization - Sum of Payroll Balance Dimension — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Help with Query optimization - Sum of Payroll Balance Dimension

Received Response
31
Views
5
Comments

Summary:

Only months into our post-implementation and our pension report query is consistently timing out.

I believe I have narrowed down the offending portion of the data model SQL code to the following and specifically the sub query at the bottom.

Looking at the line;

AND pra1.payroll_relationship_id = pra.payroll_relationship_id

If I replace "pra.payroll_relationship_id" with the hard-coded value for an employee, the query runs right away. As is, it will time out. Is there a better way to write this block or any tips you can share?

Content (please ensure you mask any confidential information):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!