![]() |
Hello,
26 Jul 2016
| 1 comment
,
|
![]() |
|
![]() |
Scenario:
18 Aug 2015
,
|
![]() |
Will optimizer check the date on which the stats are collected before suggesting the confidence levels?
14 Dec 2014
,
|
![]() |
Hello All !
17 Nov 2014
| 28 comments
,
|
![]() |
Hello,
08 Jan 2014
| 4 comments
,
|
![]() |
Database Version: Teradata 13.10.0609 13.10.06.09A
12 Aug 2013
| 5 comments
,
|
![]() |
Our Goal is we need to minimize collect sats time:
28 Feb 2013
| 3 comments
,
|
![]() |
When you start designing a statistics collection process topics include:
19 Oct 2012
| 18 comments
,
|
![]() |
has anyone else come across this? on version 13.00.01.04, release 13.00.01.03 CREATE VOLATILE TABLE test(col1 INTEGER) COLLECT STATS --help stats test; INSERT INTO test (1); --HELP STATS test; COLLECT STATS ON test; --HELP STATS test; CREATE VOLATILE TABLE test2(col1 INTEGER) COLLECT STATS HELP STATS test2; INSERT INTO test2 SELECT col1 FROM test; HELP STATS test2;
06 Dec 2011
| 5 comments
,
|
![]() |
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...
26 Sep 2011
| 7 comments
,
|
![]() |
Hello In my stored procedures, I'm looking to start recording an "audit log" after each step. So for example: /* DELETE FROM MyDatabase.MyTable_Step1 ALL; INSERT INTO MyDatabase.MyTable_Step1 /* INSERT INTO MyDatabase.AuditLog(SPName, Step, Timestmp, RowsImpacted) /* UPDATE MyDatabase.MyTable_Step1
21 Feb 2011
| 1 comment
,
|