Hey,
Can someone explain what "Sideways Information Passing" is?
I'd appreciate it!
What the heck is Sideways Information Passing?
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 96
- Joined: Thu Jul 19, 2012 12:33 am
What the heck is Sideways Information Passing?
Thanks,
Harry
Harry
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: What the heck is Sideways Information Passing?
Checkout vertica.tips for more Vertica resources.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: What the heck is Sideways Information Passing?
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.