Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 09 Dec 2011 @ 16:03:33 GMT


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


Subj:   How to identify a Bad Primary Index?
 
From:   Bodla, Sravan Kumar

HI,

Can someone please help me how can I identify a bad Primary Index?

In most of the explain plans for queries, I see "the data is duplicated on all amps", and even simple SELECT queries runs for 15-30minutes.

But the tables doesn't seems to look like having high skew.

I have used the following query to check the skew.

     SELECT DatabaseName
     , TableName
     , Vproc
     , CurrentPerm
     , PeakPerm
     FROM DBC.TableSize
     WHERE DatabaseName= 'DBNAME
     AND TableName = 'Tablename'
     ORDER BY Vproc;

Best Regards,

Sravan Kumar Bodla
TERADATA DBA



     
  <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: 27 Dec 2016