Hello,

Hello colleagues,

Scenario: Stats were collected in Teradata 12 Teradata upgraded to Teradata 14 What happens to the stats from Teradata 12?

Will optimizer check the date on which the stats are collected before suggesting the confidence levels? 

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.

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)  

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

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  

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;