#DateForumTypeThreadPost
826 Jul 2016 @ 09:48 PDTDatabaseTopicDifferent Column Orders for Stats Recommended by DIAGNOSTIC HELPSTATS? Hello, I am running into a spool space problem on tables that I just created, which had no statistics.  I employed the DIAGNOSTIC HELPSTATS ON FOR SESSION in order to get the recommended stat...
702 Jun 2016 @ 09:07 PDTDatabaseTopicSpool space and MVCHello, I was wondering if you could help me with a question that I'm researching.  I have a table that utilizes multi-value compression and it is taking up about 100 units of Current...
627 Apr 2016 @ 12:57 PDTDatabaseTopicAddition of Statistics Significantly Degrading Query Run Time? Hello colleagues, I have a query that I have been building, which has a DBS time that I'm satisfied with, but I was trying to improve.  I decided to turn on the DIAGNOSTICS HELPSTATS ON F...
524 May 2014 @ 08:32 PDTDatabaseTopicWhy is this statistic recommended?Hello fellow Teradata-ers, Our Teradata system was recently upgraded to Teradata 14.10 and we have been working on tuning our queries to perform a little bit better.  In doing so, we are usin...
408 Jan 2014 @ 07:35 PSTDatabaseTopicStatistics Creation on Tables and Stat Subsets to Enable Faster Join QueriesHello,  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 follo...
305 Aug 2013 @ 11:54 PDTToolsReply64-bit TPT Tools versus 32-bit TPT ToolsThank you; I am wondering, if we were to build an interface via the TPT API, would we notice a performance benefit over the 32-bit version? 
202 Aug 2013 @ 10:13 PDTToolsTopic64-bit TPT Tools versus 32-bit TPT ToolsHello everyone,   In installing TPT v14, I noticed that there appeared to be a 32-bit version and a 64-bit version of the utilities.  I was wondering if there were any pros or cons of u...
122 Jul 2013 @ 06:41 PDTToolsTopicZip/GZip Support in TTU 14?Hello everyone, I am currently operating in TTU 13.10 and have been reading about TTU 14, pending an upgrade that I found out we are due to receive; I noted that in the TPT Reference Manual for Ve...