Hash Index in Teradata

Hash index in Teradata has been designed to improve the performance of Teradata query in a way similar to the Single Table Join Index, which restricts parsing engine not to access or redistribute the base table. It may act like … Read more »

Join Index in Teradata

A join index is an indexing structure containing columns from multiple tables, specifically the resulting columns from one or more tables. Rather than having to join an individual table each time the join operation is needed, the query can be … Read more »

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 »