Database Object Types
Table 22 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. |