Skip to Main Content

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!

getting to slow when fetching million rows from excel to oracle using power query(through ODBC Conn)

User_X872ANov 20 2022

Thank you so much for your great help!
I want to fetch multiple values of multiple tables using power query in excel. And also used join condition in this query. Apprx 2m rows to load data into excel sheet. Please see below example of my query which is exactly similar to my scenario.

select col1,col2,col3...coln
from table1 a
left join table2 b
on a.uid=b.uid
left join table c
on b.uid=a.uid
left join table d
d.xid=b.yid
where conditions,....
and ...
,
,
and ... ;

Regards,
nk

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2023
Added on Nov 20 2022
5 comments
921 views