Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Dec 2011 @ 15:35:41 GMT


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


Subj:   Re: Tables which don't have stats
 
From:   DAVID WILLIAMS

This how I do that:

     SEL TRIM(DATABASENAME) || '.' || TRIM(TABLENAME)  (TITLE'') FROM
     SYSDBA.REFRESH_TABLE_LIST A WHERE NOT EXISTS

     ( SEL DATABASENAME, TABLENAME
          FROM
             (SEL DATABASENAME,
                     TABLENAME
             FROM DBC.COLUMNSTATS
             WHERE FIELDSTATISTICS IS NOT NULL
             GROUP BY 1,2

                     UNION

             SEL DATABASENAME,
                       TABLENAME
              FROM DBC.MULTICOLUMNSTATS
             WHERE COLUMNSSTATISTICS IS NOT NULL
              GROUP BY 1,2

                    UNION

             SEL DATABASENAME,
                           TABLENAME
             FROM DBC.INDEXSTATS
             WHERE INDEXSTATISTICS IS NOT NULL
             GROUP BY 1,2) B
          WHERE A.DATABASENAME = B.DATABASENAME
            AND A.TABLENAME    = B.TABLENAME);


     
  <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