Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 19 Nov 2004 @ 02:24:36 GMT


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


Subj:   Re: PMON explain for running query - Large discrepancy between "Estimated I/O" and "Actual I/O"
 
From:   Andrew Schroter

You can also query a dbc view while the query is stuck in a step to see what kind of skew you're seeing in spool. Set the query to retrieve amp usage for each amp, not a total for all amps. The step may be redistributing rows where one of the next step's JOIN columns is non-unique, such as lots of NULLS. Believe me, I've seen that happen.


Andy



     
  <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: 15 Jun 2023