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.

Glen



     
  <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: 15 Jun 2023