Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> join vs. IN on remote query
I have a need to do one of the following, and I am trying to get information on which one would be "best" to use:
select f1,f2 from case_header_at_r435
where case_id in (select case_id from case_tmp);
-OR-
select f1,f2 from case_header_at_f435 rch, case_tmp ct where rch.case_id = ct.case_id;
Here's more info:
The remote database is 7.3
The local databse is 8i
The remote table (case_header) will have a lot more records
than the local table (case_tmp). 10's of thousands vs. hundreds
typically.
The case_id field can be (is) indexed on both tables.
My questions:
Which method is faster?
Where is temp storage used in each method?
Which database is shouldering how much of the load in each method?
Which method is "better"?
Any other questions, hints, tips, thoughts?
Thanks,
rodney
Received on Tue May 02 2000 - 00:00:00 CDT
![]() |
![]() |