|
|
Archives of the TeradataForum
Message Posted: Sun, 29 Jul 2007 @ 09:34:04 GMT
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
| |