![]() |
Hi All,
I'm looking for a way to manually generate create table (as another table) script. The output should be script because I need to edit it.
My final goal is to create table (regular table without columnar) as columnar table.
Can anyone please assist?
Thanks,
03 Jul 2016
| 2 comments
,
|
![]() |
Teradata partitioning was originally released in V2R5.0. This presentation reviews partitioning and the changes to this feature (from DPE to columnar) that have occurred over the last twelve years.
06 Aug 2015
,
|
![]() |
This presentation explains how to physically implement a classic Star design with central fact table surrounded by several de-normalized dimension tables on Teradata.
30 Jan 2014
,
|
![]() |
You know about how the athlete coming off the bench is inserted into a game and radically alters the team play such that the team coasts to victory. A Game Changer! So too, is Columnar Partitioning, radically altering the process of physical data model development to ease application migration to Teradata Database.
09 Aug 2013
,
|
![]() |
Have you ever struggled over whether, or how, to use a new database feature? In this presentation, we’ll demonstrate how database query log (DBQL) data can help when it comes to determining candidates for MLPPI (Multi-Level Partitioned Primary Index) as well as the new Columnar Partitioning feature of Teradata 14.
03 Apr 2013
,
|
![]() |
Go in-depth on how NULLs and Compression are managed in a Teradata system.
02 Mar 2012
,
|
![]() |
|
![]() |
Let's start by understanding what a primary index does. A primary index (PI) is used to distribute the rows of a table to the AMPs and on each AMP to order the rows by hash value within the combined partitions defined by a PARTITION BY clause (if this clause is not specified, there is just one partition, that is, the entire tabl
18 Oct 2011
| 5 comments
,
|
![]() |
Teradata 14.0 introduces Teradata Columnar – a new option to organize the data of a user-defined table or join index on disk. Teradata Columnar offers the ability to partition a table or join index by column. It introduces column-storage as an alternative choice to row-storage for a column partition and autocompression. Column partitioning can be used alone in a single-level partitioning definition or with row partitioning in a multilevel partitioning definition.
27 Sep 2011
| 45 comments
,
|