Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 20 May 2011 @ 12:17:21 GMT

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

Subj:   Re: Find the number of rows of all tables in a database?
From:   Barrineau, Claybourne

This can be very expensive, as an alternative...if you collect stats on TableX Column Partition for all tables (this is highly recommended post 12.0.3), then you could quickly pull row counts from the catalog's statistical information (Dieter's (uber sql man) code is utilized...check the Teradata forum's 'attachment' listing for ' New version of stats query for TD12.0.3.1/TD13.0.0.21').

Granted, the row counts will only be as accurate as the last time you collect partition stats on the table.



  <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