| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: efficient compare
Alfredo Novoa wrote:
>
> If the two sets are sorted or indexed a O(n) algorithm is trivial. If
> they are not, you might use hashing or to sort them first.
Sorry I am not following. O(n) what? In number of msgs or size of total
data transferred? Either case, it does not sound efficient, here is the
algorithm for the latter, assuming n is the number of items in the set A
union B
send A to B, A execute A=A union B
send A to B, B execute B=A union B
Or were you talking bit complexity?
I want to do some kind of hashing... Received on Sat Apr 22 2006 - 06:21:29 CDT
![]() |
![]() |