Home Page for the TeradataForum
 
), --should this be one per col or min/max? min(), cur_perm * ((cnt (float))/sum(cnt) over ()) as approx_perm from

Archives of the TeradataForum

Message Posted: Tue, 30 Oct 2007 @ 15:01:11 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: How to find Partitioning Space?
 
From:   Mushtak Mirajkar

Dieter,

Thanks for your response.

I tried differently; some how this query is not working for me. May be I got something wrong some where. I mentioned as under :-

     select
          partition,
          count(*) as cnt,
          min(
, (select sum(currentperm) as cur_perm from dbc.tablesize where databasename = '
' --this is tablename or db name? and tablename = '') dt group by 1 ;

Will you please have a look at it and respond what I missed?


Mushtak Mirajkar.



     
  <Prev Next>   <<First <Prev Next> Last>>  
 

Attachments

Library

Quick Reference

 

Archives

Sample Index

2016  2007
2015  2006
2014  2005
2013  2004
2012  2003
2011  2002
2010  2001
2009  2000
2008  1999

 

2007 Indexes

Jan  Jul
Feb  Aug
Mar  Sep
Apr  Oct
May  Nov
Jun  Dec


 
 
 

 
 
           
  Top Home Privacy Feedback  
    Copyright for the TeradataForum (TDATA-L), Manta BlueSky     Copyright 2016 - All Rights Reserved     Last Modified: 15 Jun 2023