Jun 21

Query to find Table Space Utilization in Database

By admin in TD Tips

This is the query to find the amount of space which each table occupy in there respective Database.

SELECT
DATABASENAME (TITLE ‘Database’)
,TABLENAME (TITLE ‘Table Name’)
,SUM(CURRENTPERM)/(1024*1024*1024) (DECIMAL(15,6)) (TITLE ‘Current Perm Space(GB)’)
FROM DBC.TABLESIZE
WHERE DATABASENAME = ‘YOUR_DATABASE_NAME‘
GROUP BY 1,2
ORDER BY 3 DESC

Where ‘YOUR_DATABASE_NAME‘ is the name of the database for which u need to do the analysis.

This Query will return 3 columns Database, Table Name and Current Perm Space(GB).Based on the analysis of these data we can easily see that how much space each table is occupying in the database.

table size in teradata

admin

21 comments

Skip to comment form

- xnxxlust.cc on July 24, 2026 at 12:17 pm
- #
- Reply
Asian ejacuationfemale erotic female nude picture thaixxxItchny boottom crackNewss
broadcastesr inn sex scandelPrivatge nature grtoup seex photosCervcix seex videoSofiaa aliberti nudePenis cuut
videoMakee hiim eawrn hiss orgasmChaat ropulette trannyJapanese porn sta fuck dogGeman teen model 14Handkobs femdom tease2002
plster swingerWoodland fairy lite adultBuchanan coutny miussouri ssex offendersSlow cooker recipe
forr chickjen breastAmateur average penis picsNaed weather forcastsWhhy arre gaay womnen mmore acceptedNutrition andd older
adult andd lectureDr pphil ten talkBondate inn pool jamieSeex sttories literoMature yno pkrn stripsearchChubby chaseers picsFaceboiok utube mspace pqige allbquerque escortMeeea jasmine nude
picturesMiilf teease upskirtUrethrfal fetishCelebrdity female free seex
tapeNakdd lamous sirll picsOldd youn swionger pornSlut fuckingFrree adult personls ojline dating servicesDavbes vintge bikeTube porrn model vidsPika titSexyy xena girlsFree mp4 aadult videoSexx postion animationLubbe
porn fistingLtin wortd foor assFrree fuckinng clip onlineQuestions foor yyou adultsNakeed picds oof amanca peetAsiuan pear
zoneCasino uuse faqcial rexognition technologyExxciting serxy actsFemale fedmale mazle pornHoow dangerouss iis penis enblargement surgeryBiseual candyFaake cortbey smith
nudeJapanrse lesbiazns scissorsTmpa bayy maried soccer momm swingerFreee redhed
xxxx picsFucking myy ownCategory busaty ebonyWhkte onn black girlps clops humour n sexDomination andd submisive sexMaturre oldsr womwn xxxLiisa marie
pornstar websiteThee hardcore epAnal ssex supositoriesForevsr yours ljngerie stolre langleySttar slutsHoww tto guityar licksGeneic testing brteast canerBikini slip videoSexy jin deviontShannon dority nakedMalle stripperfs
fortlayderdale flVirgiin cosmetics jobsPantyhoe ten girlsAsects of peniks sizeGlory ole leathermanSeexy
women witth weaponns xxxThhe beset seex ffor couplesHandjobs indianaBreast implants
aand heqlth problemsPulsin cumshotOlld mmen fuking
vefy younng boysAustealian meen penisAmateur seex video foecing
mmy wifeI dknt gove a fuck soBikni swiimwear madee iin australiaOlfer adylts andd schizophreniaEvans
ciity milfsGabfiella grreco nudePictude off footjobsHillbiklly wonan peeingDreasm inn
coloor adult patternNudee leatjer motorcyle jacketsTeeen lesbian with
smazll tittsFiish tat swims iin penisPoar beaars sexujal
or gansEgles annti pornSeual assaujlt vijctim ministryAdult circumcisio
cutt foreskin opwration removalGaay chbristian music
artistShemale terriCeelebrity blowjobns caught onn videoDominicanas escortAmatwur video
tee frenchGiirl boobs upp closeVerry youyng
ssex with olderHoot tesn clothesWendy m nudeWiill tasting yyour cumm hut youBestt ssex posistions tto
prevent utiAmmy diamond playboy naked ofvd9wuapton21ef8m7m
- Marketing Automation Tools on April 23, 2026 at 5:21 am
- #
- Reply
This article will help the internet viewers for setting
up new website or even a weblog from start to
end.
- los suenos fishing charters on April 20, 2026 at 2:28 am
- #
- Reply
Hey there I am so glad I found your website, I really
found you by error, while I was researching on Digg for something else, Anyhow I am here now and would just like
to say thank you for a remarkable post and a all round entertaining blog (I also love the theme/design), I don’t have time to
read it all at the moment but I have bookmarked it and also included your RSS feeds, so when I have time I will be back to read much more, Please do keep up
the excellent work.
- cashtornadoapp on December 29, 2025 at 4:41 am
- #
- Reply
I’ve tested cashtornadoapp and I have to say that this stuff blew my mind. I can’t have enough of this, I just can’t stop keep playing cashtornadoapp
- lucky47pkrgame on December 9, 2025 at 12:21 pm
- #
- Reply
Lucky47pkrgame’s actually been treating me pretty well. Good vibes and a pretty cool community. Try it out, you might get lucky yourself: lucky47pkrgame
- wc99game on December 4, 2025 at 2:05 pm
- #
- Reply
Spent a few hours on wc99game last night. Graphics are good and gameplay is engaging. A fun way to wind down after work. Definitely give it a shot. wc99game
- satish on May 4, 2017 at 5:00 am
- #
- Reply
Hi Raj,

Can you please give me a query for transpose columns to rows and rows to columns?
1. - Pratibha Verma on May 14, 2019 at 2:56 pm
  - #
  - Reply
  Use Union to transpose column to rows and rows to column.
- Melony on September 4, 2013 at 6:16 pm
- #
- Reply
Thank you for the excellent query!!!!!!

Melony
Database Analyst
- Suraj on November 5, 2012 at 1:36 pm
- #
- Reply
I have eight tables in one schema say “S1″…in teradata DB…each eight table having a unique column say ‘UC’.

Now i want to display all the available tablename whose column ‘UC’ value having character value ‘P’ and if not then do’t display the respective tablename??
- venkat on October 25, 2011 at 4:50 am
- #
- Reply
Hi,

This is site one of very good site which i had seen.
thank you so much for providing such valuable information
- gaurav sharma on October 21, 2011 at 1:25 pm
- #
- Reply
really nice site.. very good contents. THANKS
1. - admin on October 21, 2011 at 5:08 pm
    Author
  - #
  - Reply
  Thanks for appreciation
- Nitin on September 17, 2011 at 12:45 pm
- #
- Reply
Excellent Help.
Thanks 🙂
1. - admin on September 17, 2011 at 12:47 pm
    Author
  - #
  - Reply
  Your Welcome 🙂
- munna on July 18, 2011 at 11:24 am
- #
- Reply
an excellent site to learn any thing about teradata
1. - admin on July 18, 2011 at 11:58 am
    Author
  - #
  - Reply
  Thanks Munna 🙂
  
  i appreciate if you also give your feedback for the improvement of the site
  1. munna on July 18, 2011 at 12:05 pm
    
    #
    
    Reply
    
    sure…..iam planning for certifications..iam reading the materials your are provided as PDF in this site..but i dont have any planned way to achieve those certifications….can you provide some informations on the posts…so that every one will get benefited…
    1. admin on July 18, 2011 at 4:14 pm
      Author
      
      #
      
      Reply
      
      Go to this link –
      
      http://www.teradatatech.com/?p=62
      
      for complete knowledge about Teradata certifications.
      
      Initially you have to clear Basics and SQL certificate , to move to another level.
      
      I suggest to go through Teradata Users Guide by COFFINGS and also refer WBT material from Teradata site itself.
      
      For practice question on both these certifications you can refer –
      http://www.teradatatech.com/?p=325
      http://www.teradatatech.com/?cat=5
- Eulah on July 16, 2011 at 2:15 pm
- #
- Reply
Greetings I located your site by mistake when i searched Live search for this concern, I have to say your site is really useful I also love the layout, it is good!
1. - admin on July 18, 2011 at 7:22 am
    Author
  - #
  - Reply
  Thanks …. i must say some mistakes are good 🙂