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