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 ;-)


  <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