All Forums Database
vniri.teradata 18 posts Joined 01/09
18 May 2009
How to find disk space used by a table.

Hi ,I would like to know the disk space used by a table.I am loading a 500MB file as a sample and would like to know the disk space teradata will use. This is a part of scaling later, where I intend to load a 20Gig file.Thanks in advance.Best RgdsNick

joedsilva 505 posts Joined 07/05
18 May 2009

SELECT SUM(CURRENTPERM) ACTUALSPACE, MAX(CURRENTPERM)*(HASHAMP()+1) EFFECTIVESPACEFROM DBC.TABLESIZEWHERE DATABASENAME = 'mydb' AND TABLENAME = 'mytable';

visakhcr 46 posts Joined 11/07
27 May 2009

This should give the space in MB.SELECT SUM(CURRENTPERM)/(1024*1024) ACTUALSPACE, (MAX(CURRENTPERM)*(HASHAMP()+1))/(1024*1024) EFFECTIVESPACEFROM DBC.TABLESIZEWHERE DATABASENAME = 'DB_NAME' AND TABLENAME = 'TABLE_NAME';

Regards,
BB

M_teradata 3 posts Joined 02/12
23 Feb 2012

Hi joedsilva

 

I am new to teradata,  recently shfted to teradata.

can any one give the differnces between TERADATA and OTHER RELATIONAL DBMS. i am in bit confusion.

You must sign in to leave a comment.