calculate the size of a table in teradata

Database
Enthusiast

calculate the size of a table in teradata

My question is as calculating the weight that can occupy a table in the database knowing that will add about 120 million records in a table, the insert will be done through the Multiload. What I want is to know how much space you use database before inserting the information.

Tags (1)
1 REPLY
Supporter

Re: calculate the size of a table in teradata

select 
databasename,
tablename,
sum (currentperm)/1024**3 as current_GB
from dbc.allspace
where tablename <> 'All'
and databasename = 'yourDB'
group by 1,2
order by 1,2