What the heck is Sideways Information Passing?

Moderator: NorbertKrupa

Post Reply
harryrundles
Intermediate
Intermediate
Posts: 96
Joined: Thu Jul 19, 2012 12:33 am

What the heck is Sideways Information Passing?

Post by harryrundles » Thu Oct 15, 2015 8:26 pm

Hey,

Can someone explain what "Sideways Information Passing" is?

I'd appreciate it!
Thanks,
Harry

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: What the heck is Sideways Information Passing?

Post by NorbertKrupa » Thu Oct 15, 2015 9:43 pm

IEEE Article.

More articles at vertica.tips.
Checkout vertica.tips for more Vertica resources.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1806
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: What the heck is Sideways Information Passing?

Post by JimKnicely » Tue Oct 20, 2015 12:59 pm

Here is some additional info. on SIPS:
  • SIPS is only available if the predicate is on the "inner table".
  • SIPS is only available for HASH join prior to Vertica 6.0. In vertica 6.0 and higher, SIPS will take place for HASH and MERGE joins
  • SIPS can not occur for OUTER JOIN or FULL OUTER JOIN when the fact table is the OUTER... SIPS is available for an OUTER JOIN when OUTER is the dimension (inner) table
  • SIPS will not be used if the OUTER table (fact) needs to be re-segmented
  • SIPS is not available for queries using an ANY/ALL predicate (e.g., SELECT * FROM test WHERE test.a = ANY(SELECT b FROM test2); )
  • The decision to use SIPS is a static decision based on the rules above; IT IS NOT based on statistics
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “New to Vertica Database Administration”