The following table gives a brief description of different database object types.
Object Type | Object | Description |
---|---|---|
Indexes | Join Index | Theses objects do not have data, therefore only dictionary information is processed. |
Hash Index | ||
Macro | Macro | Theses objects do not have data, therefore only dictionary information is processed. |
Procedures | Stored Procedure | These objects have data, therefore dictionary and data information is processed. |
External Stored Procedure | ||
Java JAR Stored Procedures | ||
Tables | Journal Table | These objects have data, therefore dictionary and data information is processed. Tables can be specified as individual objects with any version of the Teradata Database. |
Partitioned Primary Index (PPI) Table | ||
Table | ||
No Primary Index (NO-PPI) Table | ||
Triggers | Trigger | Theses objects do not have data, therefore only dictionary information is processed. |
User Defined Functions (UDF) | Aggregate UDF | These objects may have data depending on their usage, therefore the information is processed accordingly. |
Scalar UDF | ||
Statistical UDF | ||
Table UDF | ||
Combined Aggregate and Statistical UDF | ||
Table Function(Operator) | ||
Parser Contract Function | ||
UDF Authorization | Theses objects do not have data, therefore only dictionary information is processed. | |
User Defined Methods (UDM) | UDM | These objects may have data depending on their usage, therefore the information is processed accordingly. |
User Defined Types (UDT) | UDT | Theses objects do not have data, therefore only dictionary information is processed. |
User Installed Objects (UIF) | UIF | These objects have data, therefore dictionary and data information is processed. |
Views | View | Theses objects do not have data, therefore only dictionary information is processed. |
Globally Persistent Object (GLOP) | GLOP | Theses objects do not have data, therefore only dictionary information is processed. |
Server | Remote Server | Theses objects do not have data, therefore only dictionary information is processed. |
Schema | Schema | These objects do not have data, therefore only dictionary information is processed. |