Cloud Computing

Query 12) How to find the space utilized by particular database in teradata ?
Answers >

To find out how much space a table is using in a database use below query in Teradata:
SELECT
DATABASENAME as Database
,TABLENAME as Table
,SUM(CURRENTPERM)/(1024*1024*1024) (DECIMAL(15,6)) as Current_Size
FROM DBC.TABLESIZE
WHERE DATABASENAME = ‘YOUR_DATABASE_NAME‘
and TABLENAME=’YOUR_TABLE_NAME’
GROUP BY 1,2;

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *