Archives of the TeradataForum

Message Posted: Fri, 29 Dec 2006 @ 11:27:29 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi, Terry:

Thanks for your suggestion, I think it is a great idea to separate the Even distributed data and uneven distributed data by specific values, But these specific values probably are unstable and increasing in the future, So I should adjust UNION sql statement based on the above change,

Do you think is it possible to use secondary index or join index or Hash index to prevent high skewness for tableB on column b1 and b2?

Regards

David

	<Prev	Next>		<<First	<Prev	Next>	Last>>