), --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>>

Archives

2007 Indexes