Table slot9.WORLD.TSTA.TOAD_PLAN_TABLE
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
STATEMENT_ID varchar2 30  √  null
PLAN_ID number 0  √  null
TIMESTAMP date 7  √  null
REMARKS varchar2 4000  √  null
OPERATION varchar2 30  √  null
OPTIONS varchar2 255  √  null
OBJECT_NODE varchar2 128  √  null
OBJECT_OWNER varchar2 30  √  null
OBJECT_NAME varchar2 30  √  null
OBJECT_ALIAS varchar2 65  √  null
OBJECT_INSTANCE number 0  √  null
OBJECT_TYPE varchar2 30  √  null
OPTIMIZER varchar2 255  √  null
SEARCH_COLUMNS number 0  √  null
ID number 0  √  null
COURT_CASE_DELETE.ID Implied Constraint R
PARENT_ID number 0  √  null
DEPTH number 0  √  null
POSITION number 0  √  null
COST number 0  √  null
CARDINALITY number 0  √  null
BYTES number 0  √  null
OTHER_TAG varchar2 255  √  null
PARTITION_START varchar2 255  √  null
PARTITION_STOP varchar2 255  √  null
PARTITION_ID number 0  √  null
OTHER long 0  √  null
DISTRIBUTION varchar2 30  √  null
CPU_COST number 0  √  null
IO_COST number 0  √  null
TEMP_SPACE number 0  √  null
ACCESS_PREDICATES varchar2 4000  √  null
FILTER_PREDICATES varchar2 4000  √  null
PROJECTION varchar2 4000  √  null
TIME number 0  √  null
QBLOCK_NAME varchar2 30  √  null
OTHER_XML clob 4000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021


Close relationships: