JOIN INDEX IN TERADATA

Dear Readers, In this article , we will see JOIN INDEXES 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… Read More

Transient Journaling

Dear Readers, In this article, we will see Transient Journaling in Teradata Transient Journaling Journals Journals are kept on the system to provide data availability in the event of a component or process failure in the system: Recovery journals Permanent journals Recovery Journal The Teradata… Read More

HASH INDEX IN TERADATA

Dear Readers , In this article, we will see Hash indexes in Teradata. Hash indexes are file structures that share properties in common with both single-table join indexes and secondary indexes. From an architectural perspective, the incorporation of auxiliary structures as a transparently embedded element… Read More

SHOW LOCKS UTILITY

SHOW LOCKS UTILITY Dear Readers, In this article , we will see show locks utility in Teradata. What is SHOWLOCKS ? When a table or database is being backed up, it places a HUT lock on the object, which is released when it finishes backup… Read More

ACCESS RIGHTS IN TERADATA

 ACCESS RIGHTS IN TERADATA Hi  Readers, This article contains types of access(Privileges)  in Teradata. What is a privilege ? A database privilege is a permission to access or to manipulate a database object or data. Privileges are sometimes called access rights, permissions, or authorizations. Privileges… Read More

Partitioned Primary Index in Teradata

Dear Readers, In this article, we will learn about Partitioned Primary Index in teradata. Partitioned Primary Index A primary index can be either Partitioned OR Non-partitioned Primary indexes for join and hash indexes can also either be hash- or value-ordered, while primary indexes for all… Read More

COMPRESSION IN TERADATA

Dear Readers, In this article, we will learn about COMPRESSION IN TERADATA. We all know that now-a-days how many transactions are happening per day in this digital world. To store those data in data warehouse we need more storage disk. So everyone is looking for… Read More

PERMANENT JOURNAL

PERMANENT JOURNAL Dear Readers, In this article, we will learn about PERMANENT JOURNAL IN TERADATA The permanent journal in Teradata provides the capability to capture the snapshot of  permanent tables before and after applying changes using DML statements like insert, delete and update. Copies of… Read More