REF in Oracle 8, are they faster than JOIN?

From: <rsundar_at_my-dejanews.com>
Date: Fri, 02 Oct 1998 12:23:39 GMT
Message-ID: <6v2gka$ueq$1@nnrp1.dejanews.com>

Hi all, I am trying to use Oracle8's REF to avoid JOIN between two tables, assuming that it will be faster. But my initial experiments show that REF is taking more time (approx 4 times) than normal JOIN.

Also if I open a cursor "joining" two tables using REF, memory in the system goes on decreasing and the program dumps core for SEGV violation. (I am using a Sun Sparc)

Is REF supposed to be faster than normal JOIN? Can I use REF for m:1 relations? I use Oracle 8.0.4 on Sparc Solaris.

Sundar

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 02 1998 - 07:23:39 CDT