PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

How to find the space utilized by particular database in teradata ?

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;

Add a Comment

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