| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: tuning
Not necessarily - depends on the amount of data your are joining. If you
are joining all or most of one table to all or most of another I would think
that hash or sort join might be faster especially if you can run in
parallel, use good size sort_area_size, hash_multiblock_read.... (sorry all
of this is 8i).
Oracle OCP DBA
-----Original Message-----
Sent: Thursday, May 08, 2003 11:57 AM
To: Multiple recipients of list ORACLE-L
If two tables are the same size and you can join on a unique Primary key index, should Nested Loop join with fast full index scan be the fastest method?
Im finding that a hash join or sort merge is faster?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <rgaffuri_at_cox.net
INET: rgaffuri_at_cox.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Paula_Stankus_at_doh.state.fl.us
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 08 2003 - 11:37:13 CDT
 |
 |