Re: ideas to use ora hash

Comments inline:

On 3/22/06, Glenn Santa Cruz <glenn.santacruz_at_gmail.com> wrote:
>
> 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

Undoubtedly so. I've used that method a few times to compare table comments.

The question was whether get_hash_value could be used to do that, so that is what I did. Which was much more fun than a boring, simple, fast SQL statement. ;)

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

Hmmm. Define 'context switch', as that is not occurring, at least in the traditional sense of the term. (push registers onto stack, load new process, reload old process when done)

Jared

--
http://www.freelists.org/webpage/oracle-l