#DateWhereItemComment
6421 Mar 2016 @ 10:32 PDTcarrie's blogAMP Worker Task Resource Limits & Increased Load Limits for MLOADXThank you Carrie.
6316 Mar 2016 @ 09:35 PDTcarrie's blogAMP Worker Task Resource Limits & Increased Load Limits for MLOADXHi Carrie, is there anway to enforce the usage of MLOADX even though the target table does not have any USI/RI/JI? We're in the process of converting few of our MLOAD jobs from legacy multiloa...
6222 Jan 2016 @ 10:38 PSTPaul Sinclair's Blog on PartitioningTeradata ColumnarHi Paul, Is CPPA only supported from 15.10? We're on TD 15.0 and when I try to run: CREATE TABLE Orders (o_orderkey INTEGER NOT NULL, o_custkey INTEGER, o_orderstatus CHAR(1) CASESPECIFI...
6118 Jan 2016 @ 07:03 PSTPaul Sinclair's Blog on PartitioningTeradata ColumnarGreat explanation Paul. Thanks a lot for answering my questions. -Suhail
6018 Jan 2016 @ 01:25 PSTPaul Sinclair's Blog on PartitioningTeradata ColumnarI apologize Paul. I still don't understand the difference between the 2 schemes. You mentioned: "1. Row partitioning at first level and column partition at the next level   Column...
5918 Jan 2016 @ 10:34 PSTPaul Sinclair's Blog on PartitioningTeradata ColumnarThanks Paul. I am having a hard time understanding what Teradata does when a table is both row and column partitioned. Especially when column is at first level and row is at second level. I have a...
5818 Jan 2016 @ 08:30 PSTPaul Sinclair's Blog on PartitioningTeradata ColumnarThanks Paul. So if there is a non row partitioned CPPA table with column partition in column format on every single column solely and there is a  select query like:   select * from notr...
5715 Jan 2016 @ 09:24 PSTPaul Sinclair's Blog on PartitioningTeradata ColumnarHi Paul, Thank you for the detailed responses. You mentioned: "However, on an AMP, those table rows or their column partition values with the same PA value are not necessarily ...
5615 Jan 2016 @ 02:32 PSTPaul Sinclair's Blog on PartitioningTeradata ColumnarAlso, if a CP table has row partition, then is the row partition number stored in the container row header too?
5515 Jan 2016 @ 02:27 PSTPaul Sinclair's Blog on PartitioningTeradata ColumnarHi Paul, If we have a CPPA table, then how are the rows on the different AMPS are sorted? All rows with same PA column value go the same AMP? Are rows with the same PA column values colocated to...
5401 Dec 2015 @ 01:22 PSTToolsThe NPAM Fallback file Hi Sastry,   Thank you for the quick response. So essentially you're saying if we remove the paramters:   confirm_fallback_deletion, fallback_directory and fallback...
5301 Dec 2015 @ 12:02 PSTToolsThe NPAM Fallback fileHi, We're currently having an issue with large sizes of the fallback files. I'm wondering if there is any way: 1. To increase frequency of checkpoints so that smaller size fallback files ...
5202 Sep 2014 @ 09:04 PDTPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsThanks Paul.
5129 Aug 2014 @ 09:50 PDTPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsThanks Paul. Do you know which future release will allow treating CURRENT_TIMESTAMP as constant and facilitate creation of a specific plan?
5024 Aug 2014 @ 09:29 PDTPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsHi Paul, Does timestamp partitioning in TD 14.0 work only in equality conditions? I tried the following example and i could not achieve partition elimintation when a <= or >= was used. &nbs...
4924 Mar 2014 @ 07:17 PDTcarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerThanks Carrie for your responses. -Suhail
4813 Mar 2014 @ 08:37 PDTcarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerHi Carrie,   Thank you for your elaborate response. I have some more questions:   1. In sles 10 tasm, percentages were allocated to allocation groups that may contain 1 to many&n...
4710 Mar 2014 @ 09:23 PDTcarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerThank you for this article Carrie. Some questions: 1. As per the new architecture, at what level should we be placing our utility workloads? I know it shouldn't be tactical. 2. We have 25 ...
4606 Mar 2014 @ 01:51 PSTcarrie's blogAutomatic Throttles in Teradata 14.0 and 14.10Thank you Carrie. I'll look forward to your posting.   -Suhail
4503 Mar 2014 @ 02:05 PSTcarrie's blogAutomatic Throttles in Teradata 14.0 and 14.10Hi Carrie,   I was just going through the Orange book of SLES 11 priority scheduler and one of the comments in that book was: "Workloads in the SLG tiers can consume more than their wo...
4420 Dec 2013 @ 11:23 PSTr.sagner's blogColumn compress values from statisticsThank you. That explains it. Nice article btw. -Suhail
4318 Dec 2013 @ 03:27 PSTr.sagner's blogColumn compress values from statisticsI didn't understand : "It is not allowed to have statistics on the column". Can you elaborate?
4211 Dec 2013 @ 11:21 PSTPaul Sinclair's Blog on Partitioning9.2 Quintillion? What's that all about?I didn't understand the ADD option. Can you elaborate?
4109 Dec 2013 @ 03:34 PSTÜber SQLWhy don't you use ALTER TABLE to alter a table?ok thanks for the confirmation Dieter. I reviewed a sample explain plan and verified that too. -Suhail      
4009 Dec 2013 @ 02:18 PSTPaul Sinclair's Blog on Partitioning9.2 Quintillion? What's that all about?I think I understand how this is working. When you run a create table having a ppi expression, teradata decides which scheme to go for: 2 bytes or 8 bytes based on the max partition value you provi...

Pages