Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Sum function causing poor performance

edited May 10, 2024 1:59AM in Core Concurrent Processing - EBS (MOSC) 2 commentsAnswered

Need help rewriting this query, it is taking hours to execute.

With Complex_query as ( Select product_name, credit, adjust, receipts… contains 412k records)

Select sum(credit), sum(adjust), sum(receipts ), program_name, transaction_number

from (select (select trx_Date) from dual where trx_number = transaction_number)invoice_date, receipts, credit, adjust

from complex_query)

Group by program_name, invoice_date

order by program_name, transaction_number;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center