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.