 |
 |
Archives of the TeradataForum
Message Posted: Wed, 25 Jun 2003 @ 20:49:07 GMT
| 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
| |
