Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 26 Jul 2016 @ 13:59:36 GMT


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


Subj:   Re: Determine the row count for all tables in a particular database
 
From:   Roth, David W

Arnoldus VanWyk wrote:

  TableStatsV and StatsV typically have multiple rows per table. I use the following query to pull the Row count from most recent statistics collection event having the highest sample rate in the hopes of getting the most accurate count.  


very nice :)


David Roth
Senior Consultant
Teradata Certified Master
Certified Scrum Master



     
  <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