Partitioned Primary Index (PPI) is one of the powerful feature of Teradata which allows a user to access a part of the table rather than full table access. This helps in improving the performance as full table scan is eliminated. … Read more »
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 »
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 »
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 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 »
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 »
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 »
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 »
In this tutorial, we will guide you on how to connect Teradata SQL Assistant to the Teradata Database using Teradata ODBC Driver and other methods. If you want to install Teradata Database in Windows, you can check out our tutorial … Read more »
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 »