SIP Runtime Filter
Hi ,
I like to verify with the community how SIP Filter is working
, my understanding is that the JOIN column of the FACT to the DIM is converted into IN list filter and push down as below attach . see #3 in the attach picture , did the FACT.PK IN part is converted to HASH(FACT.PK) IN ?
Thanks
I like to verify with the community how SIP Filter is working
, my understanding is that the JOIN column of the FACT to the DIM is converted into IN list filter and push down as below attach . see #3 in the attach picture , did the FACT.PK IN part is converted to HASH(FACT.PK) IN ?
Thanks
0
Comments
That is approximately correct. There are lots of details; we don't give out implementation specifics because we're always trying to tune and improve the implementation. So anything more specific is likely to become inaccurate from one release to the next. But SIP is discussed in some more detail on the eighth page (page #1797, it's out of a larger volume) of our recent VLDB paper:
http://vldb.org/pvldb/vol5/p1790_andrewlamb_vldb2012.pdf
Adam