Mar
21
by admin
Advantage of Partition Primary Index – Partitioned Primary Index is one of the unique features of Teradata, which is used for distribution of rows based on different partitions so that they can be retrieved much faster than any other conventional approach. Maximum partitions allowed by Teradata – 65,535 It also reduces the overhead of scanning the complete …
Feb
25
by admin
Partitioned primary index or PPI is used for physically splitting the table into a series of subtables. With the proper use of Partition primary Index we can save queries from time consuming full table scan. Instead of scanning full table, only one particular partition is accessed. Follow the example below to get the insight of PPI – …
Jan
17
by admin
What is Compression in Teradata Compression is the feature of Teradata which helps to reduce the disk storage. It is useful in reducing the disk space required by FIXED LENGTH columns or NULLS. It is a loss less compression so no data will be lost in it. We can do compression on the following data …
May
16
by admin
Before you start with SI, well I must say that as a prerequisite you must first read about the Primary index in Teradata. So after knowing about Primary index the point here is that when we already have UPI and NUPI then what’s the use of this Secondary Index? Well the best possible answer for …
Feb
21
by admin
Statistics are data demographics (or hints) used by the Teradata optimizer. There are many ways to generate a query plan for a given SQL, and collecting statistics ensures that the optimizer will have the most accurate information to create the best access and join plans. The optimizing phase of Teradata, makes decisions on how to …
Dec
25
by admin
The join index JOIN the two tables together and keeps the result set in the permanent space of Teradata. This JOIN index will hold the result set of the two table, and at the time of JOIN parsing engine will decide whether it is fast to build the result set from the actual BASE tables …
Nov
20
by admin
Each table in Teradata is required to have a primary index.Even if you did not define any primary index in CREATE table statement, the Teradata system will automatically takes very first column of the table as the primary index. The primary index defines where data will reside and which AMP receives the row. The three …
