a walk back through the joins, hashing, teradata, key selection, and arguments for and against sequence numbers. while this post is specifically related to teradata, there are some generic statements here that apply to all mpp solutions.