What's new in Customer Journeys?

Connect and learn more! ×
How to reduce execution time — 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

How to reduce execution time

Question
8
Views
0
Comments

Hi,

I have developed a report to fetch the Beginning balance and Monthly balance based on the source & category. So I have written two SQL statements with Union clauses.

First SQL statement fetches the balance from gl_balance table quickly without any issue

Second SQL statement fetches the balance from gl_je_lines ( Need Journal & category) and it takes more than 40 minutes hence report execution fails every time. so i am looking for suggestions to reduce the execution time of the report (especially the 2nd SQL statement).

I have attached a SQL query for reference.


Howdy, Stranger!

Log In

To view full details, sign in.

Register

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