Querying DBC.TableSizeV - Teradata Vantage

Use the following query to evaluate the sizing of your legacy tables. Assume the database in which the table was created is named employee_largetable and the name of the table is employee.

SELECT SUM(CurrentPerm)
FROM DBC.TableSizeV
WHERE DatabaseName = ‘Employee_LargeTable’
AND TableName = ‘Employee’;

The information returned is similar to this:

Sum(CurrentPerm)
          2,527,232