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;

What is the best way to extract the output of the 'Help statistics DbName.TblName column Partition;", for the purpose of extracting the value of the column 'Number of Rows'. If you have attempted this through SQL, please share your thoughts. What I've already have in place is the following methodology...
Run 'Collect Statistics on DbName.TblName Column (Partition);
Run 'Help Statistics DbName.TblName Column (Partition);' through BTEQ with SideTitles on

Hello

In my stored procedures, I'm looking to start recording an "audit log" after each step.

So for example:

/*
* Step 1 in my Stored Proc
*/

DELETE FROM MyDatabase.MyTable_Step1 ALL;

INSERT INTO MyDatabase.MyTable_Step1
SELECT blah;

/*
* Insert Audit Log for the above step
*/

INSERT INTO MyDatabase.AuditLog(SPName, Step, Timestmp, RowsImpacted)
VALUES('MySP', 'Step 1', CURRENT_TIMESTAMMP, CountRowsImpacted() );

/*
* Step 2 in my Stored Proc
*/

UPDATE MyDatabase.MyTable_Step1
FROM ( SELECT 'blah' AS blah ) AS a
SET Col = a.blah