Chapter 2 - How Teradata Tracks Objects
“I do skid row every night.”
- Sebastian Bach
Teradata Assigns each Object a Unique Numeric ID
Your SQL uses database names, table names and column names, but each of these is actually given a numeric ID and it is that Numeric ID that the Parsing Engine (PE) and the Access Module Processors (AMPs) use to track the objects.
Each Database, User, Profile and Role is assigned a globally unique numeric ID.
Each Table, View, Macro, Trigger, Stored Procedure, User-defined Function, Join Index, and Hash Index is assigned their own globally unique numeric ID.
Each Column is assigned a numeric ID that is unique within its Table ID.
Each Index is assigned a numeric ID unique within its Table ID.
The Data Dictionary ...