Archives of the TeradataForum

Message Posted: Tue, 19 Feb 2013 @ 23:00:12 GMT

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

Not as long you collect statistics on it.

     Select , partition, count(*)
     From table
     Group by 
     Having count(*) = 0;

     --> this returns the empty partitions

Christian

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