Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 02 Jan 2013 @ 09:45:16 GMT


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


Subj:   Re: I/O, CPU and AMP SKEW
 
From:   sughesh iyyani

Thanks a lot Dave.

I have Teradata View Point access and we are using it to monitor the skew.

But in some older post in this forum, I have seen somebody mentioned we can use? SHOW CPU SKEW, SHOW IO SKEW and SHOW AMP SKEW before a query and we can analyze the skewing without executing the same. Its just like EXPLAIN.

Unfortunately I lost particular mail from my mail box.

Do you know any other techniques (like DD tables) to get the SKEW.

If we have any other method to get the skew without executing the query (like explain) it will be great.

Kindly advise me.


Thanks in advance,

Sughesh I S.



     
  <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: 23 Jun 2019