Archives of the TeradataForum

Message Posted: Wed, 25 Jun 2003 @ 17:25:15 GMT

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

Good question.

Two thoughts.

My first thought would be using the DBC.TABLESPACE to find all tables below a certain size. Since an empty table has some pace you would have to figure it out. But... You could figure out a maximum possible size for an empty table and then run collect(*) for those tables under that limit.

Second thought. Would be using statistics on the primary index to figure it out. Risk here is whether stats are up to date.

Glen

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