Tags for stats
Different Column Orders for Stats Recommended by DIAGNOSTIC HELPSTATS?
Hello,
stats
Addition of Statistics Significantly Degrading Query Run Time?
Hello colleagues,
stats statistics query optimization
Teradata Stats after upgrade
Scenario: Stats were collected in Teradata 12 Teradata upgraded to Teradata 14 What happens to the stats from Teradata 12?
stats statistics teradata 14 upgrade
confidence levels wrt date of stats
Will optimizer check the date on which the stats are collected before suggesting the confidence levels? 
stats
How to decide about Stats for new queries
Hello All !   I am bit new to Teradata and started working on it couple of months back.   I working on performance tuning suggestions for some new queries.   Wondering if anybody can help on: How we can decide for the stats for new queries. I mean, the queries which are not in production yet.
query stats tuning
Statistics Creation on Tables and Stat Subsets to Enable Faster Join Queries
Hello,  Consider the following situation:  Table Alpha has the following columns: Col1 Col2 Col3 Col4 Col5 Primary Index (Col1, Col2, Col3, Col4)   Table Beta has the following columns: Col1 Col2 Col3 Col6 Col7 Primary Index (Col1, Col2, Col3)  
statistics creation stats creation statistics stats query optimization join optimization
Collect Statistics
Database Version: Teradata 13.10.0609  13.10.06.09A Provider Version: ODBC 14.00.00.04   CREATE TABLE MY_TABLE AS ( SELECT COL1  , COL2  , COL3 FROM DB_TABLE )WITH DATA PRIMARY INDEX (COL1); COLLECT STATISTICS MY_TABLE INDEX(COL1);  
collect statistics stats collect statistics
Sampled Stats vs Time trade-off
Our Goal is we need to minimize collect sats time: we do use Combination for Full / Sample stats based on Row size: - Smaple 50% for all table's statitics combination for tables  > 5 Billion Rows - FULL for all table's statitics combination for tables  < 5 Billion Rows  
stats sample statitics
How to simplify your statistics collection with a queue table
When you start designing a statistics collection process topics include:
statistics queue stats collect
self deleting volatile table stats on insert select?
has anyone else come across this? on version 13.00.01.04, release 13.00.01.03 CREATE VOLATILE TABLE test(col1 INTEGER) PRIMARY INDEX(col1) ON COMMIT PRESERVE ROWS; COLLECT STATS COLUMN(col1) ON test; --help stats test; INSERT INTO test (1); --HELP STATS test; COLLECT STATS ON test; --HELP STATS test; CREATE VOLATILE TABLE test2(col1 INTEGER) PRIMARY INDEX(col1) ON COMMIT PRESERVE ROWS; COLLECT STATS COLUMN(col1) ON test2; HELP STATS test2; INSERT INTO test2 SELECT col1 FROM test; -- 1 row inserted HELP STATS test2;
volatile table stats

Pages