Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 19 Sep 2008 @ 02:07:01 GMT


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


Subj:   Re: Calculating total space for indexes
 
From:   Newell, Ray

The Collect Demographics statement will populate the DataDemographics Table and you can use the DataDemographics view to pull the data and easily calculate the index subtable sizes. Seems that many people are not aware of this statement, it is in the documentation.

     CREATE SET TABLE QCD.DataDemographics ,NO FALLBACK ,
           NO BEFORE JOURNAL,
           NO AFTER JOURNAL,
           CHECKSUM = DEFAULT
           (
            MachineName VARCHAR(30) CHARACTER SET UNICODE UPPERCASE NOT CASESPECIFIC NOT NULL,
            TableName VARCHAR(30) CHARACTER SET UNICODE UPPERCASE NOT CASESPECIFIC NOT NULL,
            DatabaseName VARCHAR(30) CHARACTER SET UNICODE UPPERCASE NOT CASESPECIFIC NOT NULL,
            DBSize INTEGER NOT NULL,
            CollectedTime TIMESTAMP(6) NOT NULL,
            AMPNumber INTEGER NOT NULL,
            ClusterNumber INTEGER NOT NULL,
            SubTableID SMALLINT NOT NULL,
            SubTableType VARCHAR(120) CHARACTER SET LATIN NOT CASESPECIFIC,
            RowCount DECIMAL(18,0) NOT NULL,
            AvgRowSize INTEGER NOT NULL,
            QueryID INTEGER,
            IndexName VARCHAR(2048) CHARACTER SET UNICODE UPPERCASE NOT CASESPECIFIC,
            DemographicsID INTEGER)
     PRIMARY INDEX ( MachineName ,TableName ,DatabaseName );


     
  <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: 28 Jun 2020