#DateWhereItemComment
6114 Mar 2014 @ 12:18 PDTÜber SQLNew StatsInfo query for TD14Hi Sivakunar, it was quite late yesterday, so I didn't read your post thoroughly. LastAccessTimestamp does not carry info about when stats where used, it's just the last time the obj...
6013 Mar 2014 @ 03:52 PDTÜber SQLNew StatsInfo query for TD14Hi Sivakunar, as you're on 13.10,did you use my old version?: StatsInfo pre-TD14   Is the access count feature enabled on your system, i.e. do other dbc views like dbc.TablesV retu...
5910 Dec 2013 @ 03:03 PSTDatabaseTeradata Express 14.0 for VMware now availableTeradata Express is a pre-configured VMWare image. When you installed VMWare Fusion you're done. Unzip Express into a folder and double-click the file (which actually is a folder) TDExpress14....
5809 Dec 2013 @ 02:13 PSTÜber SQLWhy don't you use ALTER TABLE to alter a table?Hi Suhail, there might be one specific case where this is slow: NO RANGE is defined and there are lots of rows in it. All rows matching the new partitioning will automatically be moved to the new...
5708 Dec 2013 @ 10:32 PSTÜber SQLWhy don't you use ALTER TABLE to alter a table?Hi Nishant, when you define NO DATA the stats definitions are copied, but the actual values are set to zero rows. Now when you re-collect the stats you need resources to do it, while a COLLECT FR...
5604 Dec 2013 @ 11:22 PSTÜber SQLNew StatsInfo query for TD14@tas_58: Could you please post totally unrelated questions to the forum.
5522 Nov 2013 @ 04:18 PSTÜber SQLHow to decode the binary statistics stored in dbc tables#1: yes #2: This is by purpose. You don't need to specify SAMPLE anymore in TD14, the collect stats process automatically remembers previous Sample/MaxIntervals/MaxValueLength settings.
5402 Oct 2013 @ 09:41 PDTToolsSQL Assistant Java Edition 13.11 now availableSQLA JE has been renamed, it's Teradata Studio/Teradata Studio Express :-)   Dieter
5319 Sep 2013 @ 11:40 PDTÜber SQLHow to spell a numeric value in english wordsHi Abi, could you please post totally unrelated questions as a new topic in the forums?   I don't have any expertice with sub-second temporal data, you should ask your Teradata support....
5217 Sep 2013 @ 02:26 PDTDatabaseExtracting table and column statisticsHi Ramakrishna, do you think you can embed this code in a Java Table UDF?  Then i could directly use it in a SELECT * FROM TABLE(....), would be so cooool. I'm not a Java programme...
5117 Sep 2013 @ 11:57 PDTÜber SQLNew StatsInfo query for TD14Hi Rao, strange, very strange. If this were functions in SYSLIB there would be an explanation, you simply created a non-standard version on your own. But only TD R&D can add functions to TD_SY...
5017 Sep 2013 @ 08:24 PDTÜber SQLNew StatsInfo query for TD14On 14.00.04.05 it's: DatabaseName FunctionName SpecificName FunctionId NumParameters ParameterDataTypes TD_SYSFNLIB OREPLACE oreplace2 00-00-57-0C-00-00 2 ++++ TD_SYSFNLIB OREPLACE or...
4916 Sep 2013 @ 02:20 PDTÜber SQLNew StatsInfo query for TD14Hi Rao, i just checked it, this error is returned when there an unknown function, seems like the optimizer didn't find OREPLACE.  SELECT * FROM dbc.functionsV WHERE functionname = 'O...
4816 Sep 2013 @ 02:14 PDTÜber SQLNew StatsInfo query for TD14Hi Rao, this error is afaik returned when the optimizer couldn't match the datatypes. Strange, is this at OREPLACE(ColumnName, ....)? Do you have a pre-TD14 version of OREPLACE in your defau...
4716 Sep 2013 @ 11:32 PDTÜber SQLNew StatsInfo query for TD14Hi Suhail, yes :-)   Dieter
4614 Sep 2013 @ 02:24 PDTÜber SQLNew StatsInfo query for TD14Hi Suhail, the StatsInfo view is not part of PDCR, it was just created within the PDCRInfo database at your site. And the new view doesn't show indexes without stats anymore, it was just a ni...
4511 Sep 2013 @ 10:01 PDTÜber SQLNew StatsInfo query for TD14@suhailmemon84: The old Field/Index/MultiColumnStats views don't work anymore in TD14, they're always empty. In fact it's much easier, you just have to check for those names not in dbc...
4411 Sep 2013 @ 09:55 PDTÜber SQLWhy don't you use ALTER TABLE to alter a table?  Hi Rob, thanks for your supplementary notes. Of course COLLECT STATS FROM avoids recollecting, it was one of the TD13 features i liked best, but maybe it's less well-know.   Di...
4307 Aug 2013 @ 04:12 PDTÜber SQLGlobal and session level parameters in SQLIf you know it's not the right place, why don't you post in the right place instead?   Dieter
4202 Aug 2013 @ 10:43 PDTÜber SQLGlobal and session level parameters in SQLThis approach only works for single-row tables holding those parameters.   Dieter
4121 Jul 2013 @ 07:01 PDTÜber SQLHow to spell a numeric value in english wordsHi Subbu, please open a new topic for new questions instead of commenting on a totally unrelated blog post. update tab as t set col3 = (select col3 from tab as t2 where t2.col1 = t.col1+1) Di...
4014 Jun 2013 @ 09:04 PDTÜber SQLHow to decode the binary statistics stored in dbc tables#1: should indicate statistics on a single non-indexed column   #2: If it's a multi-column stats it should be "MCol" instead of "Col", seems to be a buggy calcul...
3911 Jun 2013 @ 05:27 PDTÜber SQLHow to decode the binary statistics stored in dbc tablesWhich TD release? 32 or 64bit? I usually encountered that error when the new statistics version 4 was introduced. Could you check if there's a really old statistic with version 2 or 3? Are y...
3821 May 2013 @ 02:11 PDTToolsTeradata Parallel Transporter Reference 13.0You'll find all Teradata manuals at www.info.teradata.com. Dieter
3712 May 2013 @ 01:59 PDTÜber SQLHow to decode the binary statistics stored in dbc tablesThe interval details are still stored in a binary format in TD14. This new format is much more complicated, a BLOB instead of VARBYTE, i wouldn't try to reverse-engineer it (at least not in SQ...

Pages