17.10 - Example: Using AllSpaceV - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

The following SELECT statement displays how the space currently used by the data table named Department is distributed on each AMP:

SELECT DatabaseName,TableName,AMP,CurrentPerm FROM DBC.AllSpaceV
WHERE TableName=’Department’ ORDER BY 1,2,3 ;

Result:

DatabaseName    TableName       AMP        CurrentPerm
------------    ----------      ----       ------------  
Test            DEPARTMENT      1-0        1,024
Test            DEPARTMENT      1-1          512
Test            DEPARTMENT      1-2        1,024
Test            DEPARTMENT      1-3          512
PERSONNEL       department      1-0        2,048
PERSONNEL       department      1-1        1,536
PERSONNEL       department      1-2        1,536
PERSONNEL       department      1-3        1,536
User1           department      1-0        2,048
User1           department      1-1        1,536
User1           department      1-2        1,536
User1           department      1-3        1,536