|
Archives of the TeradataForumMessage Posted: Wed, 27 Dec 2006 @ 11:09:20 GMT
<-- Anonymously Posted: Tuesday, December 26, 2006 22:19 --> Hi: I have two large tables A and B, a1and a2 are A's PI column, b1 and b2 are B's columns(not PI). When I execute the following query, I meet a high skewness on B's columns b1 and b2 redistribution. Select * >From large_tableA A Inner join large_tableB B On A.a1 = B.b1 And A.a2 = B.b2 Could you tell me how to prevent high skewness for this case? Thanks for your help.
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||