Page 1 of 1

How to calculate the size of a table in teradata?

Posted: Wed Nov 25, 2015 7:11 pm
by ramverma
How to calculate the size of a table in teradata?

Re: How to calculate the size of a table in teradata?

Posted: Wed Nov 25, 2015 8:33 pm
by Guest
hi You can use below query to get the size of the tables on the Teradata.

select
tablename,
databasename,
sum (currentperm)/1024 as SIZE_IN_KB
from dbc.allspace
where tablename <> 'All'
and databasename = 'YOUR_DATABASE_NAME'