O'Reilly logo

Teradata Database Administration – The Fundamentals by Thomas Coffing, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5 - How Teradata Tracks Objects

“A bird does not sing because it has the answers, it sings because it has a song.”

-Anonymous

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required