Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 29 Jul 2007 @ 09:34:04 GMT


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


Subj:   Re: View statistic values
 
From:   Hanson, Robert

Dieter,

Here are the results of my tests:

     CREATE SET TABLE SYSDBA.dropme ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           field1_integer INTEGER,
           field2_decimal DECIMAL(18,0),
           field3_ts TIMESTAMP(6))
     PRIMARY INDEX ( field1_integer );

     INSERT INTO dropme VALUES( 1, 123456789012345678., TIMESTAMP '2007-07-25
     21:24:03.540000+00:00');
     INSERT INTO dropme VALUES( 2, 234567890123456781., TIMESTAMP '2007-07-26
     21:24:03.540000+00:00');
     INSERT INTO dropme VALUES( 3, 345678901234567812., TIMESTAMP '2007-06-26
     21:24:03.540000+00:00');
     INSERT INTO dropme VALUES( 4, 456789012345678123., TIMESTAMP '2007-06-27
     21:24:03.540000+00:00');

     COLLECT STATS ON dropme COLUMN field3_ts;
     COLLECT STATS ON dropme COLUMN field2_decimal;
     COLLECT STATS ON dropme COLUMN field1_integer;

     SELECT ColumnName, SUBSTR(fieldstatistics, 1, 80) AS STATS FROM
     dbc.ColumnStats WHERE databasename = 'sysdba' AND tablename = 'dropme';

     ColumnName                      STATS
     ------------------------------
     ------------------------------------------------------------------------
     ------------------------------------------------------------------------
     ----------------
     field3_ts
     D707071C112A173C02000000000000000000000000000000040000000000000020043600
     D707061A151800000000000020043600D707061A1518000000000000000000000000F03F
     0000000000001040
     field2_decimal
     D707071C112A2302020000000000000000000000000000000400010000000000350F63BA
     B4697B43350F63BAB4697B43000000000000F03F00000000000010400000000000001040
     350F63BAB4697B43
     field1_integer
     D707071C112A272C02000000000000000000000000000000040001000000000000000000
     0000F03F000000000000F03F000000000000F03F00000000000010400000000000001040
     000000000000F03F


     
  <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