Archives of the TeradataForum

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

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

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>>