Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

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


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

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