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 ? 



  • Hi Eli,

    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:


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file