), --should this be one per col or min/max? > min(),

of course min *and* max to get the date range

          >     cur_perm * ((cnt (float))/sum(cnt) over ()) as approx_perm
          > from

Archives of the TeradataForum

Message Posted: Wed, 31 Oct 2007 @ 11:41:17 GMT


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

Subj:		Re: How to find Partitioning Space?

From:		Dieter Noeth

Mushtak Mirajkar wrote:

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

Sorry, i made some mistakes when i keyed it in...

          > 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

      where databasename = 'databasename'name?
      and tablename = 'tablename') dt

     > group by 1 ;

Dieter


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

Archives

2007 Indexes