Secondary Index in Teradata

A Secondary Index(SI) offers an alternative path to access the data. Unlike Primary Index which can only be defined at the time of table creation, a Secondary Index can be create/drop after the creation of the table also. There are … Read more »

Primary Index in Teradata

Primary Index is the physical mechanism for storing and retrieving data row in Teradata AMP. Each table in Teradata must have at least one column as Primary Index. It is defined at the time of creating table. If any change in … Read more »

Teradata Data Types

Each column in a table is associated with a data type. Data types simply denote the type of data that we can store in any particular column. For example, for storing string data like “James” into a column we need … Read more »

Life Cycle of a Teradata Query

Teradata users or any other applications submit a query in the form of SQL (Structure Query Language) and receive the answer. But behind the scene, it has to pass many tests which determine its fate. Below are the steps which … Read more »

Know your Teradata system configuration

It may come to your mind that how many Nodes, Amps, PEs are there in your development and production Teradata system in which you are working on daily basis. Know your Teradata system configuration as below. To check the Teradata system … Read more »

Teradata Installation Guide

Do you want to install Teradata in your PC and start practicing today? Here is the  Teradata installation guide with screenshots. Teradata releases pre-installed image for Teradata Express for Vmware Workstation/Player. By installing this, you can access teradata from your … Read more »

Teradata Architecture

The main components of Teradata Architecture are PE(Parsing Engine), BYNET, AMP(Access Module Processor), Virtual Disk. Following is the logical view of the architecture: Parsing Engine When a user fires an SQL query it first gets connected to the PE (Parsing … Read more »

Introduction to Teradata

What is Teradata? Teradata is a RDBMS (relational database management system) which includes below features: It’s built on completely parallel architecture which means single task will be divided into smaller chunks and compute simultaneously hence faster execution. Teradata system is … Read more »