Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 25 Jun 2003 @ 20:49:07 GMT


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


Subj:   Re: Finding Empty Tables
 
From:   Dieter Nöth

Dempsey, Mike wrote:

  I would suggest using the TableSize. An empty table generally has a header of 1K / AMP. (Allow 1.5 or 2K if you want to be sure not to miss any empty tables and dont mind a few false positives.)  



As a table header may be up to 64KB, depending e.g. on # of columns/usage of Compress/PPI, you'll miss a lot ;-)

But when you query tables with less than 64KB/AMP and exactly the same size on each AMP, you'll hardly miss any ;-)


Dieter



     
  <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