ABBREVIATIONS IN TERADATA

ABBREVIATIONS IN TERADATA Hi Readers, This article contains  all the abbreviations in Teradata. AccessRight Column Value Description AE ALTER EXTERNAL PROCEDURE AF ALTER FUNCTION AP ALTER PROCEDURE AS ABORT SESSION CA CREATE AUTHORIZATION CD CREATE DATABASE CE CREATE EXTERNAL PROCEDURE CF CREATE FUNCTION CG CREATE… Read More

SHOWLOCKS UTILITY

SHOWLOCKS UTILITY Dear Readers. In this article ,we will see SHOWLOCKS UTILITY The Show Locks utility, showlocks, provides information about Host Utility (HUT) locks placed on databases and tables by the Archive/Recovery (ARC) utility during database operations. These locks might interfere with application processing and… Read More

VARIOUS TABLES IN TERADATA

VARIOUS TABLES IN TERADATA Dear Readers. In this article ,we will see VARIOUS TABLES IN TERADATA Teradata supports the following table types to hold temporary data. Derived Table Volatile Table Global Temporary Table Derived Table Derived tables are created, used and dropped within a query.… Read More

STATISTICS COLLECTIONS AND RECOMMENDATIONS

STATISTICS COLLECTIONS AND RECOMMENDATIONS Dear Readers. In this article ,we will see STATISTICS COLLECTIONS AND RECOMMENDATIONS Statistical information is vital for the optimizer when it builds query plans. But collecting statistics can involve time and resources. By understanding and combining several different statistics gathering techniques,… Read More

REGEXP_SUBSTR IN TERADATA

REGEXP_SUBSTR IN TERADATA Dear Readers. In this article ,we will see REGEXP_SUBSTR IN TERADATA Purpose  Extracts a substring from source_string that matches a regular expression specified by regexp_string. REGEXP_SUBSTR supports 2, 3, 4, or 5 parameters. Syntax  Where, TD_SYSFNLIB    : the name of the database… Read More