Teradata Aster Data by Coffing Tom;Nolan John; & John Nolan

Author:Coffing, Tom;Nolan, John; & John Nolan
Language: eng
Format: epub
Publisher: Coffing Publishing
Published: 2013-08-15T00:00:00+00:00

A Join With No Redistribution or Duplication

Both tables have the same Hash Key, and it is the join condition of CustNo. The matching rows are already on the same vworker because both tables joined on CustNo and their Distribution Key is on CustNo. Aster wants no unnecessary movement.

Aster Hates Joining Tables with a Different Distribution Key

The matching rows do NOT distribute to the same vworker.

CustNo is the join condition, but the matching customer numbers are on different vworkers. This is because the Order_Table is Distributed by Hash on Order_Number. Aster will redistribute the Order_Table by a Hash of CustNo so that the matching rows are on the same vworker. This is one of the things Aster hates to have to do.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.