Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Tuning SQL queries
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)
Tagged:
1