Columnar

The purpose of a Columnar(NoPI) table is to spread the rows evenly across the AMPs. This is why a NoPI table is often used as a staging table. Columnar Table Fundamentals Columnar Tables must be a NoPI Table so No Primary Index (NoPI). The NoPI brings even distribution to the table. Columnar Tables allow Columns to be Partitioned. An...

Continue Reading...

Creating Tables

table, th, td { border: 1px solid black; } th, td { padding: 5px; text-align: left; } Creation Type SQL Creating a Table with a Unique Primary Index CREATE TABLE EMP_TABLE ( EMP_NO INTEGER ,DEPT_NO INTEGER ,FIRST_NAME VARCHAR(20) ,LAST_NAME CHAR(20) ,SALARY DECIMAL(10,2) ,ADDRESS VARCHAR(100) ) UNIQUE...

Continue Reading...

TPT in deatail

Teradata Parallel Transporter supports the following types of SQL statements: Data Manipulation Language (DML): Insert, Update, Delete, Upsert, Merge, and Select Data Control Language (DCL): Give, Grant, and Revoke Data Definition Language (DDL): Create, Drop, Alter, Modify, Delete Database, Delete User, and Rename OS Commands Use...

Continue Reading...

Teradata15 features

Teradata 15.0 has come up with many new exciting features and enhanced capabilities. This post provides brief descriptions of the new features in this release in database level. JavaScript Object Notation: JSON (JavaScript Object Notation) is new functionality to support the storage and processing of data into Teradata database. A...

Continue Reading...

DATE Functions

As part of Domain Specific Functions Teradata database 14 has released new DATE functions. Below re list of function. table.tableizer-table { border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif font-size: 12px; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid #ccc; } .tableizer-table th { background-color:...

Continue Reading...

Numeric Functions

Teradata 14 has released many Domain Specific Functions. Now we are discussing about new Numeric functions which are equivalent to Oracle. The following numeric functions are available in this Teradata 14 release. table.tableizer-table { border: 1px solid #CCC; font-family: Helvetica, Arial, serif font-size: 12px; } .tableizer-table...

Continue Reading...

Regular Expression Functions

In this Teradata 14 has released many domain specific function added NUMERIC data type, String functions and many of the functions supports regular expressions. These new functions are designed to be compatible to Oracle. Here we are going to discuss about the following domain specific regular expression functions. REGEXP_SUBSTR REGEXP_REPLACE  REGEXP_INSTR ...

Continue Reading...

A to Z Performance Tuning

A) Explain the EXPLAIN: Check for EXPLAIN plan to see how exactly Teradata will be executing the query. Try to understand basic keywords in Explain Plan like confidence level, join strategy used, re-distribution happening or not. B) Collect STATS: The stats of the columns used join conditions should updated. Secondary Indexes without...

Continue Reading...