Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Finding Empty Tables
From:   Glen Blood

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.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016