Oracle-L: RE: tuning

From: Nicoll, Iain <IAIN.D.NICOLL_at_saic.com>
Date: Thu, 08 May 2003 08:57:16 -0800
Message-ID: <F001.00593F33.20030508085716@fatcity.com>

I'd imagine it should be faster if the only data you're after is in the primary keys. Isn't a fast full index scan the equivalent of a full table scan (where it's not doing any filtering) but if you need data that's not in the index you have to go out to the table for every row.

Iain Nicoll

-----Original Message-----
Sent: 08 May 2003 16:57
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: Nicoll, Iain
INET: IAIN.D.NICOLL_at_saic.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------