|
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
|