Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 29 Jan 2015 @ 12:23:41 GMT


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


Subj:   Re: TD14 Optimised stats collection
 
From:   Robert Briggs

Unfortunately it's a little more complicated than just a "simple" grouping. Here is a sample SHOW output..

     COLLECT STATISTICS
                 COLUMN ( FinanceNumber ) ,
                 COLUMN ( LaborCode2 ) ,
                 COLUMN ( DesignationActivityCode ) ,
                 COLUMN ( TADate ) ,
                 COLUMN ( StartTime ) ,
                 COLUMN ( StartTimeDecimal ) ,
                 COLUMN ( StartDate ) ,
                 COLUMN ( OperationID ) ,
                 COLUMN ( WeekID ) ,
                 COLUMN ( EmpID ) ,
                 COLUMN ( EmpID ,WeekID ,TADate ) ,
                 COLUMN ( WeekID ,TADate ,FinanceNumber ) ,
                 COLUMN ( WeekID ,TADate ,LaborCode2 ) ,
                 COLUMN ( EmpID ,TADate ) ,
                 COLUMN ( TADate ,LaborCode2 ) ,
                 COLUMN ( EmpID ,WeekID ) ,
                 COLUMN ( WeekID ,FinanceNumber ) ,
                 COLUMN ( WeekID ,OperationID ) ,
                 COLUMN ( TADate ,FinanceNumber ) ,
                 COLUMN ( EmpID ,WeekID ,FinanceNumber ) ,
                 COLUMN ( EmpID ,WeekID ,TADate ,FinanceNumber ) ,
                 COLUMN ( LaborCode2 ,FinanceNumber ) ,
                 COLUMN ( EmpID ,TADate ,LaborCode2 ) ,
                 COLUMN ( EmpID ,TADate ,FinanceNumber )
                     ON edwacctngprod.TACSStartTimeOperActuals ; COLLECT STATISTICS
                  USING MAXVALUELENGTH 40
                 COLUMN ( EmpID ,WeekID ,OperationID ,LocalUnitID ,TADate,DesignationActivityCode
                            ,LaborCode2 ,FinanceNumber ,RouteNumber ,RouteNumber3 )
                     ON edwacctngprod.TACSStartTimeOperActuals ; COLLECT STATISTICS
                  USING SYSTEM SAMPLE
                        AND MAXVALUELENGTH 35
                 COLUMN ( EmpID ,StartDTM ,WeekID ,OperationID ,LocalUnitID )
                     ON edwacctngprod.TACSStartTimeOperActuals ;

Bob Briggs TDCM
Teradata Certified Master
EDW Infrastructure and Operations Group
USPS



     
  <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: 23 Jun 2019