Re: ideas to use ora hash

  • From: "Glenn Santa Cruz" <glenn.santacruz@xxxxxxxxx>
  • To: jkstill@xxxxxxxxx
  • Date: Wed, 22 Mar 2006 13:37:42 -0600

At first glance, I'd guess this is much more CPU intensive than the
table comparison technique Tom Kyte pointed out at
http://www.oracle.com/technology/oramag/oracle/05-jan/o15asktom.html

Both techniques would full-scan the tables, but the HASH_VALUE would
have plenty of SQL to PL/SQL context switches.  Of course, this is
merely an opinion, and I'd certainly be interested in the results (may
have to try this one on my own, later tonight.)

Glenn

On 3/22/06, Jared Still <jkstill@xxxxxxxxx> wrote:
> Here's a prototype.
> This code is not optimized.  :)
>
<snip>
--
http://www.freelists.org/webpage/oracle-l


Other related posts: