#DateWhereItemComment
3604 Jan 2013 @ 06:28 PSTDatabaseRemoving Multi-Column Statistics – A Process for Identification of Redundant StatisticsThere's an older version on my stats query on the TeradataForum. You'll find the latest version on DevEx: http://developer.teradata.com/node/9598 Dieter
3525 Nov 2012 @ 10:13 PSTÜber SQLHow to simplify your statistics collection with a queue tableStrange, there should be an attachement area right to the headline of this blog entry. You could try to empty the browser cache. Otherwise this is the direct link: http://developer.teradata.com...
3424 Nov 2012 @ 06:57 PSTÜber SQLHow to decode the binary statistics stored in dbc tablesI posted a new version of my stats query fixing another bug.
3323 Oct 2012 @ 02:28 PDTÜber SQLHow to decode the binary statistics stored in dbc tablesI posted a new version of my stats query fixing some bugs.
3223 Mar 2012 @ 03:50 PDTRobG's blogDetermining Month-End Date for a Date DimensionAnother reason, why "date MOD 100" is bad: It will produce wrong results for any date before 1900. Dieter
3101 Feb 2012 @ 11:21 PSTDatabaseStatistics Collection Recommendations for Teradata 12Hi Carrie/Laeeq, instead of parsing table DDL partitioning columns can be extracted from dbc.TableConstraints, too. See "PartitioningColumn" in my new stats query: http://developer.teradata.co...
3021 Jan 2012 @ 01:41 PSTÜber SQLMissing Functions: PERCENTILE_DISC, PERCENTILE_CONT & MEDIANAnswered at http://forums.teradata.com/forum/database/qualify-rank-over-partition-question#comment-18797 Dieter
2911 Jan 2012 @ 11:20 PSTÜber SQLHow to decode the binary statistics stored in dbc tablesAssuming a 64-bit TD13: stats_64bit.sql Dieter
2821 Dec 2011 @ 07:18 PSTÜber SQLGlobal and session level parameters in SQL"So are you saying that we can not use the above sub query if we have more than one row getting returned from the sub query?" YES. You will never be able get this dispatcher retrieve step whe...
2721 Dec 2011 @ 05:53 PSTÜber SQLGlobal and session level parameters in SQLIf you use "=" in TD13 you should see this step. Could you post the actual query and the actual explain? Dieter
2621 Dec 2011 @ 05:07 PSTÜber SQLGlobal and session level parameters in SQL You can use IN (or "= ANY"), but the optimizer has to rewrite it as a join: SELECT * FROM MY_PARTITIONED_TABLE MPT WHERE PARTITION_DATE IN (SELECT MY_DATE FROM MY_PARAMETER_TABLE GROUP BY 1); ...
2519 Dec 2011 @ 11:05 PSTÜber SQLGlobal and session level parameters in SQLIf the subquery returns more than a singlke row you have to switch to IN instead of =, but this will always require a join. Regarding the syntax error in TD12: "In TD13 there's the new "Scalar ...
2402 Dec 2011 @ 12:27 PSTÜber SQLGlobal and session level parameters in SQLHi Joe, DETERMINISTIC simply means: when you call the function with the same input value multiple times, it will always return the same result. NOT DETERMINISTIC e.g. when the UDF uses some rando...
2302 Dec 2011 @ 10:33 PSTÜber SQLGlobal and session level parameters in SQLHi Joe, it's even worse, i tried it on a VMWare 13.10.00.14 with a single PE: When i logoff and logon again, it's still using the old value from the previous session (without setting the queryban...
2201 Dec 2011 @ 11:44 PSTÜber SQLGlobal and session level parameters in SQLHi Joe, this is strange, Teradata doesn't cache any results, it's not MySQL :-) Is the queryband set on transaction or session level? Is the old value actually visible in explain after changin...
2130 Nov 2011 @ 08:08 PSTÜber SQLGlobal and session level parameters in SQLHi Joe, you probably confuse me with someone else :-) I never did a compression session at Partners (i just wrote a basic SP to calculate the most common values a few years ago). But at Partn...
2030 Nov 2011 @ 12:17 PSTÜber SQLMissing Functions: PERCENTILE_DISC, PERCENTILE_CONT & MEDIANI don't think you will be able to get high confidence for this join. Maybe adding a foreign key might help, but why do you actually want it? The estimated number would probably not change. B...
1929 Nov 2011 @ 11:02 PSTÜber SQLGlobal and session level parameters in SQLHi Joe, yep, that's it. Explain doesn't show SYSLIB.getQueryBandValue (0,'dbname'") anymore, but the actual value. Dieter
1826 Aug 2011 @ 01:43 PDTÜber SQLMissing functions: CUME_DIST & NTILEHi Sal, you better don't try to rewrite translate & replace using plain Standard SQL. Just use the existing oreplace/otranslate from the Oracle UDF package or wait for TD14. Dieter
1711 Aug 2011 @ 08:55 PDTÜber SQLMissing Functions: PERCENTILE_DISC, PERCENTILE_CONT & MEDIANDid you mean OLAP UDF? Yes, you can write your own OLAP functions (in C) in TD13.10, there's a DENSE_RANK example in the "SQL External Routine Programming" manual. But it's probably quite hard...
1619 Jul 2011 @ 01:09 PDTRobG's blogUsing INTERVAL to Add or Subtract Fractional Seconds to or from TIMESTAMP ValuesTeradata doesn't know that '2011-07-19 02:18:37' is supposed to be a timestamp and as a date it's not valid. SELECT (CAST(TIMESTAMP '2011-07-19 02:18:37' AS DATE) - DATE '1970-01-01') * 86400 +...
1517 Jul 2011 @ 09:46 PDTÜber SQLMissing Functions: PERCENTILE_DISC, PERCENTILE_CONT & MEDIANHi Egor, i know those queries, i wrote them a few years ago :-) The 1st is exactly the same as the SQL:2008 calculation, I only changed the AVG calculation from aggregate to OLAP. Dieter
1421 Jun 2011 @ 03:58 PDTÜber SQLMissing functions: CUME_DIST & NTILEHi Emkay, Excel's PERCENTILE is the same as another missing function: PERCENTILE_CONT. I just finished my post on it: http://developer.teradata.com/blog/dnoeth/2011/06/missing-functions-percen...
1326 May 2011 @ 12:01 PDTDatabasePartitioned Primary Indexes (PPI): Getting StartedWhy don't you post questions like this in the forum? Is there any relation to the topic of this article? This seems to be a very basic question and you should be able to answer it when you kno...
1219 May 2011 @ 12:12 PDTDatabaseExpanded Teradata Express Family AvailableAFAIK there will be no more Windows version of TDE, only VMWare. But you can download the "Teradata Express TTU Package" at http://developer.teradata.com/node/7314 to install the Windows client. ...

Pages