Skip to main content

SIP Runtime Filter

  • January 10, 2014
  • 1 reply
  • 5 views
eli_revach
Forum|alt.badge.img+2
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 ? 
image
Thanks 

 


    1 reply

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • January 10, 2014
    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:

    http://vldb.org/pvldb/vol5/p1790_andrewlamb_vldb2012.pdf

    Adam
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement