Find Skewed Tables in DBC.TableSizeV | Teradata Vantage - Finding Skewed Tables in DBC.TableSizeV - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1093
lifecycle
previous
Product Category
Teradata Vantage™

You can query the DBC.TableSizeV view to determine if data for a given table is evenly distributed across all AMP vprocs.

SELECT vproc,CurrentPerm
FROM DBC.TableSizeV
WHERE Databasename = 'RST'
AND Tablename = 'Message'
ORDER BY 2 desc;

The output lists the AMPs in order of the space they use for the Message table, from the most to least space used. See Example of Finding Skewed Tables by Querying the TableSizeV View.