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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Tuning SQL queries

edited Nov 27, 2020 2:51PM in Reporting and Analytics for HCM 2 comments

Summary

Does anyone have any hints or tips they can share on techniques to tune SQL queries in BI Data Models?

Content

I have a BI Report which contains a single data model and returns payroll run result data. The report runs fine in most cases and completes within a minute or so. However I have tried running it against a very large payroll (circa 60,000 employees) and it is failing to complete successfully. I've tried extending the SQL query time out setting but its still not completing in time. 

The SQL query itself is fine, in terms of the table joins etc... (I have taken the SQL query directly from User Entity)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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