Archives of the TeradataForum
Message Posted: Fri, 09 Dec 2011 @ 16:03:33 GMT
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;
Sravan Kumar Bodla
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|