EXPLAIN PLAN IN TERADATA

EXPLAIN PLAN IN TERADATA   In this article, we will see the explanation of plan in Teradata Explain plan is the step-by-step English translation of a query plan generated by the parsing engine. Explain plan can give you a clear picture the way optimizer will… Read More

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