Table TBASE2.TBASE2.EXPLAIN_STATEMENT Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
ID Column Type Size Nulls Auto Default Children Parents Comments
0 EXPLAIN_REQUESTER varchar 128
EXPLAIN_ARGUMENT.EXPLAIN_REQUESTER SQL070118163138060
EXPLAIN_OBJECT.EXPLAIN_REQUESTER SQL070118163138030
EXPLAIN_OPERATOR.EXPLAIN_REQUESTER SQL070118163138000
EXPLAIN_PREDICATE.EXPLAIN_REQUESTER SQL070118163138050
EXPLAIN_STREAM.EXPLAIN_REQUESTER SQL070118163138080
EXPLAIN_INSTANCE.EXPLAIN_REQUESTER SQL070118163137990
1 EXPLAIN_TIME timestamp 16,6
EXPLAIN_ARGUMENT.EXPLAIN_TIME SQL070118163138060
EXPLAIN_OBJECT.EXPLAIN_TIME SQL070118163138030
EXPLAIN_OPERATOR.EXPLAIN_TIME SQL070118163138000
EXPLAIN_PREDICATE.EXPLAIN_TIME SQL070118163138050
EXPLAIN_STREAM.EXPLAIN_TIME SQL070118163138080
EXPLAIN_INSTANCE.EXPLAIN_TIME SQL070118163137990
2 SOURCE_NAME varchar 128
EXPLAIN_ARGUMENT.SOURCE_NAME SQL070118163138060
EXPLAIN_OBJECT.SOURCE_NAME SQL070118163138030
EXPLAIN_OPERATOR.SOURCE_NAME SQL070118163138000
EXPLAIN_PREDICATE.SOURCE_NAME SQL070118163138050
EXPLAIN_STREAM.SOURCE_NAME SQL070118163138080
EXPLAIN_INSTANCE.SOURCE_NAME SQL070118163137990
3 SOURCE_SCHEMA varchar 128
EXPLAIN_ARGUMENT.SOURCE_SCHEMA SQL070118163138060
EXPLAIN_OBJECT.SOURCE_SCHEMA SQL070118163138030
EXPLAIN_OPERATOR.SOURCE_SCHEMA SQL070118163138000
EXPLAIN_PREDICATE.SOURCE_SCHEMA SQL070118163138050
EXPLAIN_STREAM.SOURCE_SCHEMA SQL070118163138080
EXPLAIN_INSTANCE.SOURCE_SCHEMA SQL070118163137990
4 SOURCE_VERSION varchar 64
EXPLAIN_ARGUMENT.SOURCE_VERSION SQL070118163138060
EXPLAIN_OBJECT.SOURCE_VERSION SQL070118163138030
EXPLAIN_OPERATOR.SOURCE_VERSION SQL070118163138000
EXPLAIN_PREDICATE.SOURCE_VERSION SQL070118163138050
EXPLAIN_STREAM.SOURCE_VERSION SQL070118163138080
EXPLAIN_INSTANCE.SOURCE_VERSION SQL070118163137990
5 EXPLAIN_LEVEL char 1
EXPLAIN_ARGUMENT.EXPLAIN_LEVEL SQL070118163138060
EXPLAIN_OBJECT.EXPLAIN_LEVEL SQL070118163138030
EXPLAIN_OPERATOR.EXPLAIN_LEVEL SQL070118163138000
EXPLAIN_PREDICATE.EXPLAIN_LEVEL SQL070118163138050
EXPLAIN_STREAM.EXPLAIN_LEVEL SQL070118163138080
6 STMTNO integer 4
EXPLAIN_ARGUMENT.STMTNO SQL070118163138060
EXPLAIN_OBJECT.STMTNO SQL070118163138030
EXPLAIN_OPERATOR.STMTNO SQL070118163138000
EXPLAIN_PREDICATE.STMTNO SQL070118163138050
EXPLAIN_STREAM.STMTNO SQL070118163138080
7 SECTNO integer 4
EXPLAIN_ARGUMENT.SECTNO SQL070118163138060
EXPLAIN_OBJECT.SECTNO SQL070118163138030
EXPLAIN_OPERATOR.SECTNO SQL070118163138000
EXPLAIN_PREDICATE.SECTNO SQL070118163138050
EXPLAIN_STREAM.SECTNO SQL070118163138080
8 QUERYNO integer 4
9 QUERYTAG char 20
10 STATEMENT_TYPE char 2
11 UPDATABLE char 1
12 DELETABLE char 1
13 TOTAL_COST double 8
14 STATEMENT_TEXT clob 2097152
15 SNAPSHOT blob 10485760  √  null
16 QUERY_DEGREE integer 4

Table contained 5,072 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 EXPLAIN_REQUESTER + EXPLAIN_TIME + SOURCE_NAME + SOURCE_SCHEMA + SOURCE_VERSION + EXPLAIN_LEVEL + STMTNO + SECTNO Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc SQL070118163137970

Close relationships: