I suggest it to be ROWCOL because you have many columns to match against
in your second table (column qualifiers).
-Usman
Should the Bloom filter be ROW or ROWCOL?
Vishal
On Fri, Mar 11, 2011 at 11:44 AM, Lars George <lars.geo...@gmail.com>
wrote:
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
>>
--
Using Opera's revolutionary email client: http://www.opera.com/mail/
