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

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.)


On 3/22/06, Jared Still <jkstill@xxxxxxxxx> wrote:
> Here's a prototype.
> This code is not optimized.  :)

Other related posts: