Archives of the TeradataForum

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

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

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>>