0 - 3 of 3 tags for cppi
Teradata 14.0 for Business (Webcast)

In this session, we explore the features and functions available in Teradata 14.0 that will have a direct impact on the business community.

By DebraH, 19 Feb 2013 | Tagged: temporal cppi character partitioned index fast export without spool teradata 14.0
Character PPI question

Hi,
I'm new to Teradata and have a question on creating a table with a CPPI.
I have a table with a few hundered million rows. I want to create partitioning on a column called SAP_CODE whose structure is always four digits. The first digit is alphanumeric the last 3 digits are numeric, e.g. S001, M123, Z012.

By HelmutR, 16 Jan 2013 | Tagged: teradata index ppi character primary partition cppi | 2 comments
Character Partitioning directly on column (no CASE_N or RANGE_N defined)

Hi,

Is there any way to partition directly on a small (ie. CHAR(3)) character column, without defining a CASE_N or RANGE_N for the column (ie. partition on all unique values of the column)?

By lokmac, 04 Oct 2011 | Tagged: index ppi partitioning character primary partition cppi partitioned | 1 comment