Table Detail Report
SHARED_VALUE_GTTD
Column Section | Top of Page |
Table-level Detail
Description: | Shared Value Global Temporary Table Delete |
Definition: | This table is an Oracle global temporary table. It is used to improve performance for various queries. It typically will contain ids or other numerical values that will be used in a join clause or in-list in a select statement. The data in this table will be deleted by Oracle when a commit is executed. |
Table Type: | ACTIVITY |
Column Detail - SHARED_VALUE_GTTD
Column Name | Type | Null? | Definition |
---|---|---|---|
SOURCE_ENTITY_NAME | VARCHAR(100) | Y | Contains the name of where the shared_entity_values come from. An example of this would be table name if you were storing table ids in the value column. |
SOURCE_ENTITY_VALUE | DOUBLE | Y | Contains numeric values. An example of these would be primary key ids from a table. |