15.00 - Querying DBC.TableSizeV - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Querying DBC.TableSizeV

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 might look something like this:

    Sum(CurrentPerm)
          2,527,232