64 | 21 Mar 2016 @ 10:32 PDT | carrie's blog | AMP Worker Task Resource Limits & Increased Load Limits for MLOADX | Thank you Carrie.
|
63 | 16 Mar 2016 @ 09:35 PDT | carrie's blog | AMP Worker Task Resource Limits & Increased Load Limits for MLOADX | Hi 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... |
62 | 22 Jan 2016 @ 10:38 PST | Paul Sinclair's Blog on Partitioning | Teradata Columnar | Hi 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... |
61 | 18 Jan 2016 @ 07:03 PST | Paul Sinclair's Blog on Partitioning | Teradata Columnar | Great explanation Paul. Thanks a lot for answering my questions.
-Suhail
|
60 | 18 Jan 2016 @ 01:25 PST | Paul Sinclair's Blog on Partitioning | Teradata Columnar | I 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... |
59 | 18 Jan 2016 @ 10:34 PST | Paul Sinclair's Blog on Partitioning | Teradata Columnar | Thanks 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... |
58 | 18 Jan 2016 @ 08:30 PST | Paul Sinclair's Blog on Partitioning | Teradata Columnar | Thanks 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... |
57 | 15 Jan 2016 @ 09:24 PST | Paul Sinclair's Blog on Partitioning | Teradata Columnar | Hi 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 ... |
56 | 15 Jan 2016 @ 02:32 PST | Paul Sinclair's Blog on Partitioning | Teradata Columnar | Also, if a CP table has row partition, then is the row partition number stored in the container row header too?
|
55 | 15 Jan 2016 @ 02:27 PST | Paul Sinclair's Blog on Partitioning | Teradata Columnar | Hi 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... |
54 | 01 Dec 2015 @ 01:22 PST | Tools | The 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... |
53 | 01 Dec 2015 @ 12:02 PST | Tools | The NPAM Fallback file | Hi,
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 ... |
52 | 02 Sep 2014 @ 09:04 PDT | Paul Sinclair's Blog on Partitioning | TD 14.0 - The other partitioning enhancements | Thanks Paul.
|
51 | 29 Aug 2014 @ 09:50 PDT | Paul Sinclair's Blog on Partitioning | TD 14.0 - The other partitioning enhancements | Thanks Paul. Do you know which future release will allow treating CURRENT_TIMESTAMP as constant and facilitate creation of a specific plan?
|
50 | 24 Aug 2014 @ 09:29 PDT | Paul Sinclair's Blog on Partitioning | TD 14.0 - The other partitioning enhancements | Hi 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... |
49 | 24 Mar 2014 @ 07:17 PDT | carrie's blog | How Resources are Shared in the SLES 11 Priority Scheduler | Thanks Carrie for your responses.
-Suhail
|
48 | 13 Mar 2014 @ 08:37 PDT | carrie's blog | How Resources are Shared in the SLES 11 Priority Scheduler | Hi 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... |
47 | 10 Mar 2014 @ 09:23 PDT | carrie's blog | How Resources are Shared in the SLES 11 Priority Scheduler | Thank 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 ... |
46 | 06 Mar 2014 @ 01:51 PST | carrie's blog | Automatic Throttles in Teradata 14.0 and 14.10 | Thank you Carrie. I'll look forward to your posting.
-Suhail
|
45 | 03 Mar 2014 @ 02:05 PST | carrie's blog | Automatic Throttles in Teradata 14.0 and 14.10 | Hi 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... |
44 | 20 Dec 2013 @ 11:23 PST | r.sagner's blog | Column compress values from statistics | Thank you. That explains it. Nice article btw.
-Suhail
|
43 | 18 Dec 2013 @ 03:27 PST | r.sagner's blog | Column compress values from statistics | I didn't understand : "It is not allowed to have statistics on the column". Can you elaborate?
|
42 | 11 Dec 2013 @ 11:21 PST | Paul Sinclair's Blog on Partitioning | 9.2 Quintillion? What's that all about? | I didn't understand the ADD option. Can you elaborate?
|
41 | 09 Dec 2013 @ 03:34 PST | Über SQL | Why 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
|
40 | 09 Dec 2013 @ 02:18 PST | Paul Sinclair's Blog on Partitioning | 9.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... |