Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 22 Dec 2012 @ 20:30:15 GMT

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

Subj:   Re: Resolving AMP CPU Skew Error
From:   Dave Wellman


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)

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020