Mar 14
Click below link to start – Practice 3 You may also want to check below mentioned Sample Papers for completer reference – Practice 1 Practice 2 I have also identified few E books which is immensely useful for Teradata Certification Preparation. Please have a look and if you are seriously preparing for TD certifications then don’t …
Feb 24
Teradata is consistent with hashing a value. It means that when Teradata hashes the Index value (e.g. ‘teradatatech’) it will come up with a Row Hash. Now if Teradata hashes the same index value (‘teradatatech’) million times it will always come up with the same Row Hash. Teradata always hashes the same value with consistent …
Feb 21
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
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 …
Dec 12
Practice 2 You may also want to check below mentioned Practice Papers for completer reference – Practice 1 Practice 1 I have also identified few E books which is immensely useful for Teradata Certification Preparation. Please have a look and if you are seriously preparing for TD certifications then don’t hesitate to purchase it.(Hover the …
Nov 20
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 create the primary index based on the setting of DBScontrol setting field . The primary index defines where data will reside and which AMP receives the row. …
Aug 03
COLLECT STATS is one on the most useful utility in Teradata. It helps Parsing Engine (PE) to make an effective plan to execute query, so that less resource are utilized and performance is improvised. But there is a serious confusion between doing COLLECT STATS on column level or table level. Here i like to explain …
