Skip to Main Content
Forums

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!

how to make faster retrieve by joining two tables having 1 billion rows each?

iGeniJan 16 2023 — edited Jan 16 2023

I've 2 tables GLBALASONHIST (1 billion rows) & TB_INTEGRATED_REPORT_CONFIG(1**0 thousand rows****)**. I need to fetch some rows by joining these tables and insert those rows into a new table RTEMPGLBALHISTORYDATA.
My current query is given in the screenshot:
1.PNGthis query is taking way more time to be executed, more than 1 hr. so, I need some advice to make the execution time lesser. Is there any way to do the requirement?

.
Comments
Post Details
Added on Jan 16 2023
#oracle, #plsql, #sql, #sqldeveloper
7 comments
1,160 views
1 mention