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 …
Dec
12
by admin
// Teradata database has become so popular today that you will often find many Teradata certification courses and online Teradata certification training resources. To become an Teradata Certified Professional, you will need to learn all the Teradata certification test objectives. Most of us are concern about the practice or sample questions for various Teradata exams. …
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 …
Aug
03
by admin
// 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 …
Jul
26
by admin
Teradata 12 Certified Associate. Business user certification (Teradata 12 Certified Associate ) is the newest addition to the Teradata Certified Professional Program (TCPP). // The certification exam was developed specifically for Teradata Business Professionals who use Teradata’s technology in less technical job roles.The target audience is the Business Professionals of various fields like Marketing, Sales, …
Jun
21
by admin
This is the query to find the amount of space which each table occupy in there respective Database. SELECT DATABASENAME (TITLE ‘Database’) ,TABLENAME (TITLE ‘Table Name’) ,SUM(CURRENTPERM)/(1024*1024*1024) (DECIMAL(15,6)) (TITLE ‘Current Perm Space(GB)’) FROM DBC.TABLESIZE WHERE DATABASENAME = ‘YOUR_DATABASE_NAME‘ GROUP BY 1,2 ORDER BY 3 DESC Where ‘YOUR_DATABASE_NAME‘ is the name of the database for which …
Jun
21
by admin
Space allocation is the most primary and important part in any Database. Teradata gives us the unique set of System Tables, with the help of which, we can do some useful space allocation calculation. Sometimes when there is no more space left in the System then we need to check in the existing databases and …
