Teradata Partitioned Primary Index (PPI) 

What is the Concept behind Partitioning a Table? Each Table in Teradata has a Primary Index unless it is a NoPI table. The Primary Index is the mechanism that allows…

Read More

Secondary Index in Teradata

# Contents 1. What is Secondary Index in Teradata? 2. When we can Define Secondary Index? 3. Types of Secondary Index 4. Unique Secondary Index (USI) 5….

Read More

Teradata No Primary Index (NOPI) Table

# Contents 1. What is NO PRIMARY INDEX (NOPI) Table? 2. How’s row distributed in AMP for No PRIMARY INDEX (NOPI) table? 3. How it can be…

Read More

Hashing of the Teradata Primary Index

# Contents 1. The Hashing Formula Facts 2. Important Hashing formula Terminology 3. How Hashing Algorithm decides which AMP has the Row? 4. Hashing Theory For Non- Unique…

Read More

What is Teradata Primary Index?

# Contents 1. What is difference between Primary Keys (PK) and Primary Indexes (PI) 2. What is Primary Index? 3. The Teradata Primary Index Choice  (Which Column to…

Read More

How to connect Teradata SQL Assistant to Teradata

In this Tutorial we will learn how to connect Teradata SQL Assistant to Teradata database using Teradata ODBC drive. If you want to install Teradata Database in…

Read More

Installation and Configuration Teradata Tools and Utilities

If you want to learn and practice Teradata database Please find here the guidance how to Installation and Configuration Teradata Tools=and Utilities in your computer. The latest…

Read More

Teradata Architecture

Contents The Teradata database Architecture PARSING ENGINE (PE) Message Passing Layer(MPL) The Access Module Processor (AMP) VIRTUAL DISK (Vdisk) What is Teradata SMP and MMP System? BYNET…

Read More

What is Teradata Objects? A Tutorials & Guide

Teradata Objects Below are the list of objects contains in Teradata database or User: Tables–rows and columns of data Views–predefined subsets of existing tables Macros–predefined, stored SQL…

Read More

Teradata Basics

Major Components of Teradata: Parsing Engine The Message Passing Layer (MPL) Access Module Processor (AMP) Virtual Disk Parsing Engines (PE) Manage sessions for users Parse, optimize, and…

Read More

What is Teradata Database?

Contents What is Teradata Database? Teradata – A Brief History Why Teradata? What is a Data Warehouse? What is a Relational Database? Teradata Database Advantages The Features That…

Read More