Table TBASE2.TBASE2.EXPLAIN_OBJECT 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_STATEMENT.EXPLAIN_REQUESTER SQL070118163138030
1 EXPLAIN_TIME timestamp 16,6
EXPLAIN_STATEMENT.EXPLAIN_TIME SQL070118163138030
2 SOURCE_NAME varchar 128
EXPLAIN_STATEMENT.SOURCE_NAME SQL070118163138030
3 SOURCE_SCHEMA varchar 128
EXPLAIN_STATEMENT.SOURCE_SCHEMA SQL070118163138030
4 SOURCE_VERSION varchar 64
EXPLAIN_STATEMENT.SOURCE_VERSION SQL070118163138030
5 EXPLAIN_LEVEL char 1
EXPLAIN_STATEMENT.EXPLAIN_LEVEL SQL070118163138030
6 STMTNO integer 4
EXPLAIN_STATEMENT.STMTNO SQL070118163138030
7 SECTNO integer 4
EXPLAIN_STATEMENT.SECTNO SQL070118163138030
8 OBJECT_SCHEMA varchar 128
9 OBJECT_NAME varchar 128
10 OBJECT_TYPE char 2
11 CREATE_TIME timestamp 16,6  √  null
12 STATISTICS_TIME timestamp 16,6  √  null
13 COLUMN_COUNT smallint 2
14 ROW_COUNT bigint 8
15 WIDTH integer 4
16 PAGES integer 4
17 DISTINCT char 1
18 TABLESPACE_NAME varchar 128  √  null
19 OVERHEAD double 8
20 TRANSFER_RATE double 8
21 PREFETCHSIZE integer 4
22 EXTENTSIZE integer 4
23 CLUSTER double 8
24 NLEAF integer 4
25 NLEVELS integer 4
26 FULLKEYCARD bigint 8
27 OVERFLOW integer 4
28 FIRSTKEYCARD bigint 8
29 FIRST2KEYCARD bigint 8
30 FIRST3KEYCARD bigint 8
31 FIRST4KEYCARD bigint 8
32 SEQUENTIAL_PAGES integer 4
33 DENSITY integer 4
34 STATS_SRC char 1
35 AVERAGE_SEQUENCE_GAP double 8
36 AVERAGE_SEQUENCE_FETCH_GAP double 8
37 AVERAGE_SEQUENCE_PAGES double 8
38 AVERAGE_SEQUENCE_FETCH_PAGES double 8
39 AVERAGE_RANDOM_PAGES double 8
40 AVERAGE_RANDOM_FETCH_PAGES double 8
41 NUMRIDS bigint 8
42 NUMRIDS_DELETED bigint 8
43 NUM_EMPTY_LEAFS bigint 8
44 ACTIVE_BLOCKS bigint 8

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


Close relationships  within of separation: