Hi,
If you expect a lot of misses with that approach then enable bloom filters on
the second table for fast lookups of misses.
Lars
On Mar 11, 2011, at 9:44, Amandeep Khurana <ama...@gmail.com> wrote:
> You can scan through one table and see if the other one has those rowids or
> not.
>
> On Thu, Mar 10, 2011 at 8:08 PM, Vishal Kapoor
> <vishal.kapoor...@gmail.com>wrote:
>
>> Friends,
>> how do I best achieve intersection of sets of row ids
>> suppose I have two tables with similar row ids
>> how can I get the row ids present in one and not in the other?
>> does things get better if I have row ids as values in some qualifier/
>> qualifier itself?
>> I hope the question is not too confusing...
>>
>> intersection of {1, 2, 3} and {2, 3, 4} is {2, 3}.
>> while {1,2,3} are row ids from a table, {2,3,4} may come from other table
>> as
>> qualifiers in some row.
>>
>> thanks,
>> Vishal
>>
