Archives of the TeradataForum

Message Posted: Tue, 22 Sep 2015 @ 09:32:16 GMT

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

I would recommend to check for skew. is the partition columns resulting in a skewed processing?

If yes, you might want to try to add some columns (perhaps the PI columns) in the ORDER BY for a better distribution. I have have seen other using this technique but never tried/verified.

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