Archives of the TeradataForum
Message Posted: Sat, 22 Dec 2012 @ 20:30:15 GMT
Skewed queries are usually caused by lack of statistics on a column which has an uneven distribution of data values.
Explain the query that got aborted. Look for spool files that are "redistributed by hash code" and look to see what column(s) the spool file is distributed on. Does that column(s) contain uneven data values? If so then you probably need to collect stats on the column(s).
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|