#DateWhereItemComment
3909 Dec 2013 @ 01:58 PSTPaul Sinclair's Blog on Partitioning9.2 Quintillion? What's that all about?quick question. Can a pre-td 14 table be altered and its date partition range extended to go beyond 65535 partitions? We're on TD 14 currently. I just ran an explain of an "alter table&qu...
3808 Dec 2013 @ 12:18 PSTÜber SQLWhy don't you use ALTER TABLE to alter a table?Hello Dieter, When you run an alter statement on a very large non empty table to extend its current ppi date range, do you expect such an alter statement to run quickly without any transient journ...
3701 Nov 2013 @ 02:58 PDTkeep it simpleUpdate on copy / move data between systemsHi Ulrich, quick question. The arcmain option in this tool uses pipes right? I need to move a 7 TB table from one system to another and I don't have the hard drive space for it. Regards, Suh...
3622 Oct 2013 @ 02:02 PDTÜber SQLGlobal and session level parameters in SQLHi Dieter, I have a question regarding query banding in macros. I have a project specific requirement where I need to set a query band dynamically based on input parameters. I'm trying to achi...
3525 Sep 2013 @ 11:53 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Hello Carrie, Thank you for your response. As I mentioned before, we have a daily script that collects PARTITION stats on all partitioned tables. Post TD 14, should I change our script to collect...
3424 Sep 2013 @ 01:20 PDTPaul Sinclair's Blog on PartitioningTeradata ColumnarThanks Paul. I'm going to save this article on my desktop along with the comments. This is one of the few articles where the comments proved to be more informative than the article itself :) -...
3321 Sep 2013 @ 07:54 PDTcarrie's blogStatistics collection recommendations – Teradata 14.0Hi Carrie, From TD 14, will "PARTITION" stats on PPI tables help the optimizer in stats extrapolation at all? The reason I asked is because we have a daily script that collects sta...
3221 Sep 2013 @ 06:41 PDTPaul Sinclair's Blog on PartitioningTeradata ColumnarHi Paul, Why do we achieve better compression if we have the column partition in column format vs storing it in row format?   Also when you mentioned: "Usually a subrow is wide (mult...
3117 Sep 2013 @ 02:22 PDTMarcio MouraLet's talk about Aggregate Join Indexes (AJI)If the JI has current_Date in it, what is the best way to keep it updated? Do I need to drop it and recreate the JI every single day? Can I incrementally update such a JI? -Suhail
3016 Sep 2013 @ 11:25 PDTÜber SQLNew StatsInfo query for TD14I'm sorry for confirming this again on more time. If i create a table and add no statistics to it, the statsinfo14 view will not show it. Correct? -Suhail
2913 Sep 2013 @ 03:54 PDTÜber SQLNew StatsInfo query for TD14Hello Dieter, Another quick question. The previous pdcrinfo.statsinfo view(of 13.10) showed details of all tables: regardless of whether they had stats in them or not. Is the new view (of 14)...
2811 Sep 2013 @ 06:54 PDTÜber SQLNew StatsInfo query for TD14Alright thanks Dieter. Thats relieving. Regards, Suhail
2702 Sep 2013 @ 09:49 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskShould TPT run faster than the legacy utilities(considering we use 1 reader instance, 1 writer instance) just because one is 64 bit technology and another is 32 bit technology? Regards,...
2602 Sep 2013 @ 09:27 PDTÜber SQLNew StatsInfo query for TD14We're still at 13.10 and use the column: "missing stats" to find all those tables with no stats on them and add pi and parition stats on them. Is there a simple way to find this info?...
2502 Jul 2013 @ 08:08 PDTTeradata Performance ConsiderationsMemory on Linux Teradata Systems - How do I know if I have a problem?Hello Woody, Do you have any pointers on what form of analysis we need to do to contemplate increasing total # of AWTs from 80 to 100? Increasing AWTs can boost performance but it can very w...
2430 May 2013 @ 08:22 PDTcarrie's blogReserving AMP Worker Tasks? Don’t let the Parameters Confuse You!Hi Carrie, If we want to intelligently set the AWT Limit(rather than blindly set the value of 50), then should we be doing the following analysis? 1.Check history resusage data and probe values o...
2324 May 2013 @ 10:55 PDTkeep it simpleCalculation of Table Hash Values to Compare Table ContentHi Ulrich, How can I contact you? Regards, Suhail
2223 May 2013 @ 10:13 PDTkeep it simpleCalculation of Table Hash Values to Compare Table ContentThis is awesome. I assume you're not providing the source code for free? :) Regards, Suhail
2122 May 2013 @ 03:23 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskShould TPT run faster than the legacy utilities(considering we use 1 reader instance, 1 writer instance) just because one is 64 bit technology and another is 32 bit technology? Regards, ...
2022 May 2013 @ 03:13 PDTcarrie's blogRequest Cache Hits & Missesok. Thanks for the direction. I was thinking along the same lines too. The only way you can bound an application to a specific PE/set of PE's is by ensuring that the applica...
1922 May 2013 @ 03:06 PDTcarrie's blogSimplifying AMP Worker Task Monitoring and Getting it RightThank you for this info. I learned something today. Regards, Suhail
1819 May 2013 @ 01:06 PDTcarrie's blogRequest Cache Hits & Misseshi carrie, how can we restrict a tactical application or an ETL job to a specified PE so that its probability of a request cache hit increases? Regards, -Suhail
1718 May 2013 @ 03:36 PDTcarrie's blogHow to set a System-Level CPU limit for Capacity-on-DemandThank you Carrie for your response. Regards, -Suhail
1618 May 2013 @ 03:23 PDTcarrie's blogSimplifying AMP Worker Task Monitoring and Getting it RightHi Carrie, why are awt requirements for the first phases of a fastload vs an mload different? FastLoad or TPT Load Operator: Phase I: 3 AWTs per AMP (1 sender, 2 receivers) Phase II: 1 AWT/A...
1514 May 2013 @ 07:35 PDTcarrie's blogHow to set a System-Level CPU limit for Capacity-on-DemandHi Carrie, Based on your earlier response: "Resusage will still show the same number of CPU seconds and will still show 100% CPU utilization when a full workload is running. But each of...

Pages