SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple CTEs with large data

Doyel Barman-OracleDec 10 2023

Hello experts,

I have a query where I need to use multiple CTEs, ( it's a big dataset about 1.9 M records). The query is extremely slow when multiple CTEs are used in JOINs. What can I do for performance tuning? Any help would be greatly appreciated.

Thank you!

Added on Dec 10 2023

5 comments

1,554 views